Complicated If Equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have figured out the following formula -

=(IF(K16="1 of 4",IF(I16>60,"0",(IF(I16<11,"2",IF(I16>10,"1","2")))),0))

and it works exactly as i want it. The point here is that if K16 - "1 of 4"
then the formula goes from there. I want to be able to include a total of
three possible TRUE responses: "1 of 4" "5 of 10" and "25%"

How can i complete this formula to include the additional 2 TRUE options?

Thank you!
 
You can use the OR function to add the other scenarios.

=(IF(OR(K16="1 of 4",K16="5 of
10",K16=0.25),IF(I16>60,"0",(IF(I16<11,"2",IF(I16>10,"1","2") ))),0))

Does that help?

Steve
 
Back
Top