Assuming the value in cell BC3 is actually 73, you should not be getting an
error. The first thing I might check would be to make sure the worksheet has
been calculated (Press F9) or make sure Automatic Calculations is turned on.

Next, I'd take a closer look at the contents of cell BC3. Is it just a data
value, or is it the results of a formula? If data, try re-typing it. If a
formula, what is the formula?

HTH
Elkar


"M.A.Tyler" wrote:

Assume that the rows below are 1-5, and the following formula, also below, is
entered in BD3. Is the error because it's an odd number? More importantly can
someone suggest a fix?

Thanks!

=IF(MOD($BC3,1)=0,0,--RIGHT($BC3,LEN($BC3)-FIND(".",$BC3)))*0.1+$BC3


BC BD
72.6 73.2
71.8 72.6
73 #VALUE!
72 72
73.8 74.6