CRYPTO.HMAC¶
Creates an hash based authentication code (HMAC) for given text and secret. The used hash algorithm can be optionally specified. For a list of supported hash algorithms please refere to Hash Algorithms.
Syntax
=CRYPTO.HMAC(Text, Secret [, Algorithm])
Arguments
Name |
Description |
---|---|
Text |
A text to create hash value for. |
Secret |
A text used as key to generate the cryptographic HMAC hash. |
Algorithm |
Optional. The hash algorithm to use. Defaults to “sha256” |
Return Value
The hmac value if no error occurred, otherwise an error value.
Example
Function |
Result |
Comment |
---|---|---|
=CRYPTO.HMAC(“hello”, “top secret”) |
a28f6aee6a27565bf1b868da1947c35147039fe6482b35d3b8fdeb9592e42e99 |
By default “sha256” is used. |
=CRYPTO.HMAC(“hello”, “top secret”, “md5”) |
9ffaf5da07c95deaa000729cd65fefea |
Same text and secret as before but creates an hmac using “md5” algorithm. |