Use AI.FILL to fill an incomplete range with GPT given an example range
For example:
- =AI.FILL(C2:D4,C5:C7,1)
Syntax
AI.FILL(prompt, [value], [temperature])
Argument name | Description |
---|---|
prompt (required) | Prompt to submit to GPT |
value | OPTIONAL – Value to be concatenated at the end of the prompt |
temperature | OPTIONAL – Creativity (value between 0 and 1) Default: 0 |