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

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#formula generator
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration