Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |