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