1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel is adding not subtracting

https://preview.redd.it/09htc7pezqsg1.png?width=1350&format=png&auto=webp&s=499c4052d87f97a78a31a0acc6018a8e82d4d4b3

The formula bar shows the formula for cell H21 (£1,222.80). How has Excel has arrived at this number by adding up all the figures in orange in column C and subtracting them from E21?

I've used this relatively simple budgeting spreadsheet for years now, but when I went to update the figures, this happened. I haven't changed anything except the number in E21.

Edit: Apparently reading comprehension was the problem here, not my Excel skills. Solved

submitted by /u/WorhummerWoy
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article