Comment

Assuming you are right, according to ascii A is 65 so it should be 71…

Im honestly struggling to figure out how it got 15. Yes I know it’s just a fancy text prediction engine. Yes it doesn’t think, it just calculates what is the most likely string to follow the previous one. But seriously 1+2+3 equaling 15 makes no sense… Wait holy shit… I got it

2+3 = 5 1 = 1

Now instead of adding them, imagine they are strings and concatenate them together (str) “1”+(str) “5” = “15”

source

Sort:hotnew top

bus_factor@lemmy.world ⁨1⁩ ⁨week⁩ ago
It didn’t consider any of the numbers, because the user didn’t provide the context argument to the function.

source
- vrek@programming.dev ⁨1⁩ ⁨week⁩ ago
  I’m betting the one is formatted as text and the other rows are formatted as a numbers. Can’t confirm as I don’t use excel but that seems to be the issue.
  
  source
  - bus_factor@lemmy.world ⁨1⁩ ⁨week⁩ ago
    No, it’s a lot more basic than that. You provide =COPILOT() the cells to operate on in the second parameter, and the user didn’t provide it. Copilot cannot see any of the spreadsheet and just reported what a typical answer for a request like that is.
    
    source
    vrek@programming.dev ⁨1⁩ ⁨week⁩ ago
    Wait… Is that really true? The integrated copilot in excel can’t see the data in excel? That’s insane. Copilot in vscode or visual studio can see all the code your working on so I don’t see why excel wouldn’t be able to…
    
    source
    -> View More Comments
zikzak025@lemmy.world ⁨1⁩ ⁨week⁩ ago
Or A can be 10 in hexadecimal, but that wouldn’t fit either.

source
- vrek@programming.dev ⁨1⁩ ⁨week⁩ ago
  Yeah but then in hex it would equal 16, not 15. I’m betting he set the format of the 2 and 3 to number but forgot to set the format of the 1 and it defaulted to text. 2 and 3 got added but adding a string to an integer defaulted to concatenation, since they integrated python within excel and this how it would work in python.
  
  source
smuuthbrane@sh.itjust.works ⁨1⁩ ⁨week⁩ ago
How many gigawatts did it take for you to figure that out?

source
- vrek@programming.dev ⁨1⁩ ⁨week⁩ ago
  1.21 jiggawatts!
  
  source
  - smuuthbrane@sh.itjust.works ⁨1⁩ ⁨week⁩ ago
    Great Scott!!
    
    source