Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas not calculating correctly
How do I get formulas to calculate correctly?
I have used the following simple formula - =T20*Z20 where t20 = =IF(N20100%,"0",K20-M20) z20 = 917,000 n20 = 99.04% k20=394 m20=390 When I do the math, it should total 3,668,000, yet my total in excel is 3,457,090. Why is excel calculating this incorrectly? |
#2
|
|||
|
|||
Hi
I think its rounding problem if type figures given into excel it calculates 3668000 I presume figures in row 20 are sums of ranges Tina "MWickline" wrote: How do I get formulas to calculate correctly? I have used the following simple formula - =T20*Z20 where t20 = =IF(N20100%,"0",K20-M20) z20 = 917,000 n20 = 99.04% k20=394 m20=390 When I do the math, it should total 3,668,000, yet my total in excel is 3,457,090. Why is excel calculating this incorrectly? |
#3
|
|||
|
|||
I just checked it on a new spreadsheet and got 3,668,000. You may want to
review some of the results to see if you are getting a round off error. I'd check K20 and M20 with more decimal places to see if you really have what you think you have. I suspect that you have K20-M20=3.77 instead of 4. "MWickline" wrote: How do I get formulas to calculate correctly? I have used the following simple formula - =T20*Z20 where t20 = =IF(N20100%,"0",K20-M20) z20 = 917,000 n20 = 99.04% k20=394 m20=390 When I do the math, it should total 3,668,000, yet my total in excel is 3,457,090. Why is excel calculating this incorrectly? |
#4
|
|||
|
|||
That was it. K20 is a sum of a few other cells, where one is a decimal.
Thank you so very much. -- MWickline "Barb R." wrote: I just checked it on a new spreadsheet and got 3,668,000. You may want to review some of the results to see if you are getting a round off error. I'd check K20 and M20 with more decimal places to see if you really have what you think you have. I suspect that you have K20-M20=3.77 instead of 4. "MWickline" wrote: How do I get formulas to calculate correctly? I have used the following simple formula - =T20*Z20 where t20 = =IF(N20100%,"0",K20-M20) z20 = 917,000 n20 = 99.04% k20=394 m20=390 When I do the math, it should total 3,668,000, yet my total in excel is 3,457,090. Why is excel calculating this incorrectly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
not calculating formulas | Excel Discussion (Misc queries) | |||
Excel won't calculate my formulas correctly. | Excel Worksheet Functions | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |