GPT_COMPLETE formula
Complete cells with =GPT_COMPLETE
Use GPT to complete result from given values
=GPT_COMPLETE(rangeKeys, rangeValues, rangeKeysToComplete, temperature, model, cache)
Last updated
Use GPT to complete result from given values
=GPT_COMPLETE(rangeKeys, rangeValues, rangeKeysToComplete, temperature, model, cache)
Last updated
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
gpt-3.5
or gpt-4
gpt-3.5
bypassCache
Bypass the cache and query openai again. The results will be differents than before.
false