Incorrect Result of Formula (Excel 97)

Topic

New Reply

I cannot, for the life of me, figure out why the column I’ve highlighted in green on the attachment is returning a result of 65,820.00 instead of the correct result of 65,825.26. It’s not a rounding issue. Could I have messed up my default calculation settings and not known it?

Reply | Quote

Replies

It is a rounding issue. Cell C7 is formatted to display 2 decimals, so it shows 59.27. But the actual outcome of the formula in the cell is 59.2652620205294. If you multiply that by 1110.60, you get exactly 65,820. If you need to use 59.27 instead of 59.2652620205294, you must use ROUND in the formula for C7.

Reply | Quote

Well, duh!!!!!! I knew that!!!!!
I guess I had a quick brain lapse! Thanks again!

Reply | Quote

Well, duh!!!!!! I knew that!!!!!
I guess I had a quick brain lapse! Thanks again!

Reply | Quote

It is a rounding issue. Cell C7 is formatted to display 2 decimals, so it shows 59.27. But the actual outcome of the formula in the cell is 59.2652620205294. If you multiply that by 1110.60, you get exactly 65,820. If you need to use 59.27 instead of 59.2652620205294, you must use ROUND in the formula for C7.

Reply | Quote