Brad,

Didn't I see this before?

Use OR

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

That's if the other two inclusions are in K16

Beege.




"Brad Larsen" <BradLarsen@discussions.microsoft.com> wrote in message
news:1B2852E6-DF07-4B2C-AA24-D6728248F2D8@microsoft.com...
> 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(I16>60,"0",(IF(I16<11,"2",IF(I16>10,"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!