Getting subtraction wrong in excel

0 votes

This is absurdly simple but I am not getting what I am doing wrong, please help me out. My formula is very simple:=V40 - SUM(O40:P40,R40:S40)

The values of V40 is 107, O40 is 80, P40 is 0, R40 is 1, S40 is 0. Ideally, the result should be 107 - 81 = 26, but no matter what I do the result that comes is 0

Oct 10 in Others by Kithuzzz
• 20,660 points
46 views

1 answer to this question.

0 votes

Solution:

  1. If your values are a result of other functions check if the formulas for these functions still hold true, if not correct them.
  2. Try recreating the same formula in different parts of the worksheet/workbookif the formula works then an error is isolated to the cell where you are getting the results.
  3. Try with static values in the formula instead of dynamic, if the problem still pertains then the issue is with the cell.
  4. ** Check the format of the cell** Change it to number format.
  5. ** Check whether the calculations for the sheet/workbook are set to automatic instead of manual**
I hope this helps you.
answered Oct 10 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
544 views
0 votes
1 answer

Want to compare two columns in excel

Hello To compare two columns in excel ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
311 views
0 votes
1 answer

Spell number in excel 2013 using 2 rows

Hello, there are a few steps to ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
108 views
0 votes
1 answer

Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
569 views
0 votes
1 answer

How to trigger Excel AutoFill using power Automate?

In PAD you may want copy the ...READ MORE

answered Sep 29 in Others by narikkadan
• 37,660 points
116 views
0 votes
1 answer

Excel calculating drop rates

Each column's "total" row is just the ...READ MORE

answered Oct 29 in Others by narikkadan
• 37,660 points
37 views
0 votes
0 answers

Why is Excel not calculating the cube root as the cube root?

I think Excel treats exponents with recurring ...READ MORE

Nov 2 in Others by Kithuzzz
• 20,660 points
33 views
0 votes
1 answer

Getting SUM for hh:mm:ss in EXCEL

The times are probably preserved as text. SUM ...READ MORE

answered Oct 23 in Others by narikkadan
• 37,660 points
103 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP