Cell evaluation seems like it does incorrect math

Hi,

I have a cell (E3) that is taking an average: =AVERAGE(B3:D3). Then I have a cell (H3) using that average in a formula: =IF(E3<>0,G3/E3,0). The problem is that the results are wrong when the 2nd formula is evaluated. For example, I have the average equaling 4 in one situation. Then, I want to take 9/that average, which should equal 2.25 (9/4 = 2.25). But it gives me the answer of 2.08 for some reason. If I replace the average and just write a 4, it works out. What is going on?

I think you'll find that your problem is a rounding issue.

The value you are obtaining as an average in E3 likely has many more decimal places than what is showing. To check, you can click on E3 and then highlight the formula in the formula bar. Then hit the F9 key. Your actual value will now show in the formula bar. Now hit the Escape key before leaving the formula bar.

You might want to have your formula in H3 adjusted to have G3/ROUND(E3,0) instead of just G3/E3

Note: Change the 0 to specify the number of digits to which you want to round

Thanks, that fixes it.