Reference
No results for 'undefined'
    Powered by Algolia

    CACHE

    If cacheValue points to a lazy-cell, it will be evaluated and then it's value will be put in a cache.Uses old value on subsequent calls with the same key.‌

    Syntax

    =CACHE(cacheName, cacheKey, cacheValue)

    Parameters

    1. cacheName
      • Type: String
      • Description: Name of the cache to use.
    2. cacheKey
      • Type: Any
      • Description: Key to cache on.
    3. cacheValue
      • Type: Any
      • Description: Cache value

    Returns

    • Type: Any
    • Description: The cached value.

    Example

    =CACHE("myCache", "key1", A1)

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents