ISIN
checks if value is in a range or comma-separated list · a deepcalc original · no excel equivalent · no sheets equivalent
signature
ISIN(value, list)
returns: boolean
| argument | required |
|---|---|
| value | required |
| list | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=ISIN("apple", "apple,banana,orange") true | A | |
|---|---|
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
| 4 | 40 |
| 5 | 50 |
fx
=ISIN(42, A1:A10) false related
- FROMBYTES converts byte array to integer
- GENERATEID generates unique ID with prefix and random suffix
- HASH hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)
- IMAGE shows an image from a url — the browser loads it, the engine does not fetch
- RANDOMCHOICE random pick from a range (with replacement); count > 1 spills a column
- RANDOMINT.UNIQUE generates unique random integers in range