Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can you use a OR function in an IF function.
I'm trying to check a cell on sheet 1 for certain text such as "HS-C" "HS-U" "HS-D" "HS-R" "HS-L" "HS" "ST-C" "ST" if the cell has "HS-L" or "HS-U" or"HS-D" or"HS-R" the IF function would return "U-HS-MCS, I could probally nest the others in the False setion of the IF function. I just need to know how to group them together, without having a long nested IF function, By the way is there a limit to have many nested IF functions are allowed? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Improvements for text finding functions | Excel Discussion (Misc queries) | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions |