deepcalc
DocsHASH

HASH

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

Hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321).

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

Examples

=HASH("abc")
Result ba7816bf8f01cfea414140de5dae2223b00361a396177a9cb410ff61f20015ad
=HASH("abc", "MD5")
Result 900150983cd24fb0d6963f7d28e17f72

Syntax

HASH(text, [algorithm])
text
text required
algorithm
text optional
FROMBYTESConverts byte array to integer. GENERATEIDGenerates unique ID with prefix and random suffix. 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. RANDOMINT.UNIQUEGenerates unique random integers in range.