Formulas not calculating correctly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get formulas to calculate correctly?

I have used the following simple formula -

=T20*Z20

where t20 = =IF(N20>100%,"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
 
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.
 
That was it. K20 is a sum of a few other cells, where one is a decimal.
Thank you so very much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multi tiered percentage rent calculation 3
Formula not calculating correctly 4
adding problem with formulas 5
excel formula 3
Troubleshooting Excel 2003 calculation speeds 1
Calculation not correct after decresing decimal point 1
Formula result not displaying correctly 2
Formula to calculate time 1

Back
Top