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 `a`

, `b`

, `c`

, `d`

, `e`

, `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.