Thread: IF Function
View Single Post
  #1   Report Post  
HRMSN
 
Posts: n/a
Default 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