Returns the value of the variable passed to the function, from the cache. Before retrieving the cache variable value, the value has to be stored in the variable.
= CACHE(value)
Value |
A cache variable whose value is to be found. The value should be specified as a string (e.g., “var”). |
String. The function can be used in combination with other functions.
Example |
Returns |
= CACHE("userName") |
The userName value stored in the cache. |
= CACHE("OrderID") |
The OrderID value stored in the cache. |
= CACHE("domain") |
The domain name stored in the cache. |
= ENCRYPT(CACHE(“UserID”)) |
The encrypted version of the UserID stored in the cache. |
= DECRYPT(CACHE(“MyUsername”)) |
The decrypted version of the cache variable “MyUsername”. |