IF Function
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
|