[–] 9 points 1 year ago (1 child)

Looks like the screenshot uses the formula wrong (no context cells passed), but still... And the docs warn you not to use it for any numerical or high stakes/financial tasks lol "DO NOT USE IF ACCURACY IS IMPORTANT TO YOU" 😂

  • source
  • parent
  • context
  • [–] 8 points 1 year ago*

    There is no need to be overly dramatic. As far as i was aware i had the latest version and highest tier license making me assume i could actually test this.

    I swallow my words when provided with proof. And i will take an experienced person their world in fields I don’t have experience myself.

    There are a lot of jokes around that get mis interpreted as real facts on the current internet. You also should not automatically belief stuff online. Critical thinking and doing your own research are still important even when considering that you can fuck that part up.

  • source
  • parent
  • context
  • [–] 4 points 1 year ago

    Yeah, plenty of warnings in there about not using it for numbers.

    And also this:

    The COPILOT function only has access to data provided through the context arguments. It does not have access to:

    Other data from the workbook

    So it's optional only in that it won't even look at the spreadsheet when returning the result. I suspect the next 20 years of AI research will be teaching it to say "I'm sorry, Dave. I'm afraid I can't do that" when appropriate.

  • source
  • parent
  • context
  • [–] 2 points 1 year ago* (last edited 1 year ago) (6 children)

    I am wrong and Microsoft is even dummer then i thought to allow this.

    FYI: this image is fake.

    The sentiment is true but there is no such thing as a =Copilot() command.

    Source: My work gave me a pro license and i could not replicate this. It still absolutely sucks in every conceivable way compared with claude. The only other way is if this is a region exclusive update but even then its questionable because the implication of those cells updating live could be exploited to be very expensive for ms.

  • source
  • [–] 2 points 1 year ago (1 child)

    Passing the range is optional, as per the documentation. However, when used with a separate range parameter, it does return correct results. Note that specifying a range inside the text prompt will not work, even though it should be the exact same request sent to the model.

    I'm not sure what the intended purpose for this is, but it can return crazy numbers when doing math. You can ask it to add some cells in a completely empty spreadsheet and it'll return some random numbers.

  • source
  • parent
  • context
  • [–] 3 points 1 year ago* (last edited 1 year ago) (5 children)

    The text field says =COPILOT("sum the numbers above"). It doesn't work that way. Excel does not have any concept of what "above" means here. Those numbers are not used in the calculation whatsoever. To reference those numbers, the field should say =COPILOT("sum the numbers in", A1:A3).

    What the user did here was ask the LLM to generate some text based on a text prompt and no other data, and the LLM decided to answer with a string containing only digits.

  • source
  • parent
  • context
  • view more: ‹ prev next ›