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