ISNUMBER function will differentiate between numbers and text.

< is the opposite of =


HTH
Best rgds
Chris Lav


"HRMSN" wrote in message
...
I am trying to use the IF function to assess the following:

If any of five or so cells has a number in it (any number) then place in
this cell where the formula is, a label corresponding to the source cell
that
has a number in it.

For instance, if my staff person indicated they used 5 hours of vacation
time because they placed the number 5 in a specific cell, then I want the
letter V to be placed here.

I believe I know what to do, but what might be the simplest way to help me
is answering this. Is there a symbor or something that will indicate that
any number will do, or is there a symbor that is opposite of "="?

Hope this makes sense...

HR Specialist