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!
Your formula might look something like this ...
=IF(AND(CONDITION1,CONDITION2,CONDITION3,CONDITION 4),2,0)
Hope this helps you ...
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=515960