View Single Post
  #1   Report Post  
Lee
 
Posts: n/a
Default IF & OR Functions

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?