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?