GPT_COMPLETE formula
Complete cells with =GPT_COMPLETE
Use GPT to complete result from given values
=GPT_COMPLETE(rangeKeys, rangeValues, rangeKeysToComplete, temperature, model, cache)
Parameter
Description
Default
rangeKeys
rangeKeys range of cells (keys)
required
rangeValues
rangeValues range of cells (values)
required
rangeKeysToComplete
rangeKeysToComplete range of cells (keys) to complete it's range of cells (values)
required
temperature
Between 0 (not creative) and 2 (very creative)
0
model
standard
or advanced
(gpt-4o-mini or gpt-4o)
standard
bypassCache
Bypass the cache and query openai again. The results will be differents than before.
false
Last updated