I’m trying to work with the chat on an Excel worksheet.
I need to tell the chat the values and the formulas of a range. But it seems that the chat does not understand it.
For instance, I tried the following prompt.
Let's work on an Excel worksheet. The values of the range B5:C10 are: a 11 b 11 c 11 d 11 e 11 f 11 The formulas of the range B5:C10 are: a =10+LEN(B5) b =10+LEN(B6) c =10+LEN(B7) d =10+LEN(B8) e =10+LEN(B9) f =10+LEN(B10)
Then I asked the chat
give me the formulas of B5:B10. I expected the list of
f or an empty list. But what ChatGPT gave me was wrong:
Does anyone have any idea or workaround for this prompt engineering? At least, I would hope the chat would return the information I gave to it.