•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel is adding not subtracting
Our take
Excel's functionality continues to impress, as demonstrated in a recent budgeting scenario where the formula bar revealed a calculated total of £1,222.80 for cell H21. This figure results from adding the values in orange from column C and subtracting them from the amount in E21. Despite years of familiarity with this spreadsheet, an update led to some confusion, highlighting the importance of careful reading.
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
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Formula for adding/subtracting on a conditional value.Hi, I'm setting up a spreadsheet for my partner and I as we are consolidating our savings but want to keep track on who has what amount of money. (We are consolidating for interest reasons, not for joint finanical reasons) I have created the spreadsheet below, and basically what I want is: sum all [person b + input] subtract all [person b + output] from [sum input] to give final value of money ^^ and again for Person A I'm not good with creating my own excel functions at all, so I'm really struggling https://preview.redd.it/h858fn3cgfwg1.png?width=717&format=png&auto=webp&s=35036974049799ebec79d5daf9affc08ae8a60d9 Sorry if this doesn't make sense! submitted by /u/mudkip0099 [link] [comments]
- Small Business rounding issueHi, Can anyone identify why my spreadsheet is calculating the total to be $6133.33 instead of $6133.20? 153.33 total hours x $40/hr. I've been using the same spreadsheet for a year, the formulas are correct, this hasn't happened before, I can't figure out how to fix it. This is on sheets. Thank you https://preview.redd.it/0tzyhv5xkkxg1.png?width=708&format=png&auto=webp&s=7376ba5124c04fef83cea620b23810079a01655f https://preview.redd.it/lp1vzu5xkkxg1.png?width=702&format=png&auto=webp&s=68ca02b9d005fff97f4f69615e542d85fb02c9d1 https://preview.redd.it/5g9zi96blkxg1.png?width=1042&format=png&auto=webp&s=956143ad31c7e99cbd5551ba3f9ac9e1dff00639 submitted by /u/alicat9 [link] [comments]
- Formula works in most of the cells ant not othersI downloaded a budget excel that was basicly what i was looking for. I coped it 13 times in the work sheet one for each month and 1 for a yearly total. The yearly one is running a current total for the year for what was done so far. My issue is that most of the cells this will work in but there is one section it will not do a running total for unless i have an amount in every cell for the 12 months. Any ideas what could be the issue submitted by /u/cbeard0245 [link] [comments]
- Excel formula automatically rewriting itself??Hi all, this is a really odd problem to run into and I am unsure how to proceed from here. I am currently entering data and I have Excel performing an =SUM(B5:AC5) for my data that is being entered. Because the data entry can go pretty fast sometimes, I would keep entering data past AC5 before I realize what happened. When I look at my SUM column, Excel has flagged my =SUM(B5:AC5) formula with the error below, which is fine and whatever, but it is automatically changing my =SUM(B5:AC5) formula to =SUM(B5:AF5) or something of similar depending on what column I stopped at. Just for reference, data from AD5 to AO5 is being summed up in another column with SUM=(AD5:AO5). Formula error being flagged by Excel I have no idea why it is doing this and I tried to ignore error, but it still automatically rewriting my formula anyways! This worksheet and formula worked smoothly 4 months ago so I don't know what is going on. submitted by /u/WildKhanine [link] [comments]
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