[SOLVED] Multiple True's in IF Formula's

[Brad Larsen]

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!

[Beege]

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!

[Brad Larsen]

Yes - you did see this before - but that hasn't worked for me. Any other
suggestions?

"Beege" wrote:

> 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!
>
>
>

[daddylonglegs]

Hi Brad

Beege's suggestion seems sensible enough to me - you might try explaining why that doesn't work for you - it may make it easier for others to understand your aim.

Just looking at your initial formula I think you could tidy it up a bit, you wouldn't normally use quotes around numbers unless you have a particular reason to so...

=IF(K16="1 of 4",IF(I16<11,2,IF(I16<61,1,0)),0)

now, what's the extra bit?