I genuinely cannot think of a single use-case where you would want Excel to look at your entire spreadsheet without it being a horrible mistake. You definitely do not want AI to do math for you, and that is thankfully not what this thing is designed for.
True but I could see using Ai to write a function which does the math… Like I write a prompt (simplified example as I’m on my phone) like “sum all the values above A4 and place result in A4” and the Ai should then write the function “sum(A1, A3)” and place it in cell A4
Wow, yeah most people who want to use a function like this will mess that up…
I genuinely cannot think of a single use-case where you would want Excel to look at your entire spreadsheet without it being a horrible mistake. You definitely do not want AI to do math for you, and that is thankfully not what this thing is designed for.
True but I could see using Ai to write a function which does the math… Like I write a prompt (simplified example as I’m on my phone) like “sum all the values above A4 and place result in A4” and the Ai should then write the function “sum(A1, A3)” and place it in cell A4
You can certainly use AI to generate the function and paste it in, but that is not what
=COPILOT()is for. You could just have any other LLM do that.Maybe not what it’s intended for but I promise that’s what it will be used for…