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!

[BenjieLop]

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!

Your formula might look something like this ...

=if(and(Condition1,Condition2,Condition3,Condition4),2,0)

Hope this helps you ...

Regards.

[Kassie]

Hi Brad

Try =IF(OR(K16="1 of 4","5 of
20",0.25),IF(I16>60,"0",(IF(I16<11,"2",IF(I16>10,"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(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]

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(I16>60,"0",(IF(I16<11,"2",IF(I16>10,"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(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!

[Kassie]

Hi Brad,
Sorry for the typo! I omitted the cell addressfor the additional
conditions. It should read =IF((OR(K16="1 of 4",K16="5 of 20",K16=0.25)

"Brad Larsen" wrote:

> 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(I16>60,"0",(IF(I16<11,"2",IF(I16>10,"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(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!