Oh my, I'm sure sorry to hear that about Sandy.........he's helped me a lot
over the years. He'll be sorely missed. Thanks for letting me know.

And thanks for your concern about my absence.......I'm in my ninth year of
my Triple Bypass now, so far so good......

Vaya con Dios,
Chuck, CABGx3





"T. Valko" wrote:

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