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, 2022 in Others by Kithuzzz
• 38,010 points
1,368 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, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

Dynamic Subtraction formula in excel sheet

Excel is capable of using both a ...READ MORE

answered Jan 6, 2023 in Others by narikkadan
• 63,700 points
532 views
0 votes
1 answer

Getting data out of a cell with a #NAME? error in Excel VBA

If you need VBA, use .Formula: Dim f As ...READ MORE

answered Feb 3, 2023 in Others by narikkadan
• 63,700 points
412 views
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, 2022 in Others by gaurav
• 23,260 points
1,382 views
0 votes
1 answer

Excel feet and inches to millimeters

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

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
1,461 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, 2022 in Others by narikkadan
• 63,700 points
671 views
0 votes
1 answer

Excel calculating drop rates

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

answered Oct 29, 2022 in Others by narikkadan
• 63,700 points
604 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, 2022 in Others by Kithuzzz
• 38,010 points
215 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, 2022 in Others by narikkadan
• 63,700 points
6,012 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