deepcalc
DocsISIN

ISIN

View as markdown/docs/functions/isin.md Ask Claude about this pageOpens Claude with this page's address

Checks if value is in a range or comma-separated list.

  • Origin: A deepcalc original
  • Excel: No equivalent
  • Google Sheets: No equivalent
  • Returns: Boolean

Examples

=ISIN("apple", "apple,banana,orange")
Result true
=ISIN(42, A1:A10)
A
1 10
2 20
3 30
4 40
5 50
Result false

Syntax

ISIN(value, list)
value
any required
list
any required
FROMBYTESConverts byte array to integer. GENERATEIDGenerates unique ID with prefix and random suffix. HASHHex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321). IMAGEShows an image from a url: the browser loads it, the engine does not fetch. RANDOMCHOICERandom pick from a range (with replacement); count > 1 spills a column. RANDOMINT.UNIQUEGenerates unique random integers in range.