HASH

hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321) · a deepcalc original · no excel equivalent · no sheets equivalent

signature

HASH(text, [algorithm])

returns: text

argumentrequired
text required
algorithm optional

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

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

related

  • FROMBYTES converts byte array to integer
  • GENERATEID generates unique ID with prefix and random suffix
  • IMAGE shows an image from a url — the browser loads it, the engine does not fetch
  • ISIN checks if value is in a range or comma-separated list
  • RANDOMCHOICE random pick from a range (with replacement); count > 1 spills a column
  • RANDOMINT.UNIQUE generates unique random integers in range