I set up a test book and could not duplicate the problem. My cell BD3
returns 73, not #VALUE!

I expect that you've got a TEXT number in there instead of a real number.

HTH
Vaya con Dios,
Chuck, CABGx3




"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