When I tried it I got 73 in cell BD3, not #VALUE. Check that BC3 does
actually contain a number and is formatted as General.

Hope this helps.

Pete

On Jan 30, 5:06*pm, M.A.Tyler <Great Lakes State 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