GPT_COMPLETE formula

Complete cells with =GPT_COMPLETE

Use GPT to complete result from given values

=GPT_COMPLETE(rangeKeys, rangeValues, rangeKeysToComplete, temperature, model, cache)

ParameterDescriptionDefault

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

Last updated