Glad to hear you're ok. We lost one of our regulars recently, Sandy Mann.

I hadn't seen you "around" for a while so I was hoping nothing bad had
happened.

--
Biff
Microsoft Excel MVP


"CLR" wrote in message
...
Pretty good, thanks for asking Biff........I've been doing a bunch of
Excel
programming work and some of the basics were starting to slide away from
me.
Quite embarassing to be asked a "simple" question and not remember the
answer........so, I thought maybe a little "tune-up-time" might help.
Hope all's well with you and yours,

Vaya con Dios,
Chuck, CABGx3




"T. Valko" wrote:

Chuck, long time no see!

How you doing?

--
Biff
Microsoft Excel MVP


"CLR" wrote in message
...
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