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?

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?

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?

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?