deepcalc
DocsVALIDATE.RANGE

VALIDATE.RANGE

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

Validates value is within min and max range.

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

Examples

=VALIDATE.RANGE(50, 0, 100)
Result true

Syntax

VALIDATE.RANGE(value, min, max)
value
number required
min
number required
max
number required

Errors

#VALUE!
=VALIDATE.RANGE("alpha", 2, 2)
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. ISINChecks if value is in a range or comma-separated list. RANDOMCHOICERandom pick from a range (with replacement); count > 1 spills a column.