Multiple True's in IF Formula's
Thank you - but that's not going to work - i've tried different combinations
of that with no luck so far.
"Kassie" wrote:
Hi Brad
Try =IF(OR(K16="1 of 4","5 of
20",0.25),IF(I1660,"0",(IF(I16<11,"2",IF(I1610," 1","2")))),0))
"Brad Larsen" wrote:
Hello -
Is it possible to write a formula that includes the option for multiple true
statements?
Here my formula that works for one true statement:
=(IF(K16="1 of 4",IF(I1660,"0",(IF(I16<11,"2",IF(I1610,"1","2") ))),0))
the formula considers the true statment and then refers to another cell's
information to determine the value to include. In this case "1 of 4" is the
true statement. I want to include two other possible true statments that
follow the same formula "5 of 20" and "25%"
How can i do this?
Thank you!
|