Creating a complicated formula

I am trying to create the following formula:

I have two colums (A and B) with numbers.
Formula 1 checks if A>=5250.001 and B<=5000 then returns CIR2
Formula 2 checks if A<=5000 then returns CIR1
Formula 3 checks if A>=5250.001 and B>=5000.001 then returns OOC

I can get all three formula working individually but I need them to work
together as one formula, checking all three "ifs" and returning one of the
three results.

Can anyone help me with linking the three together or advise me if there is
a better way to calculate this?

Many thanks,

Cheryl

THIS ..?

=IF(AND(A1>=5250.001,B1<=5000),"CIR2",IF(AND(A1>=5250.001,B1>=5000.001),"OCC",IF(A1<=5000,"CIR1","")))


"Cheryl" wrote:

> I am trying to create the following formula:
>
> I have two colums (A and B) with numbers.
> Formula 1 checks if A>=5250.001 and B<=5000 then returns CIR2
> Formula 2 checks if A<=5000 then returns CIR1
> Formula 3 checks if A>=5250.001 and B>=5000.001 then returns OOC
>
> I can get all three formula working individually but I need them to work
> together as one formula, checking all three "ifs" and returning one of the
> three results.
>
> Can anyone help me with linking the three together or advise me if there is
> a better way to calculate this?
>
> Many thanks,
>
> Cheryl
>
>
>
>
>

Here's a play off Topper's formula that will take care of TEXT values as
well.....

=IF(OR(ISTEXT(A1),ISTEXT(B1)),"Improper
value",IF(AND(A1>=5250.001,B1<=5000),"CIR2",IF(AND(A1>=5250.001,B1>=5000.001),"OCC",IF(A1<=5000,"CIR1",""))))

Vaya con Dios,
Chuck, CABGx3



"Cheryl" wrote:

> I am trying to create the following formula:
>
> I have two colums (A and B) with numbers.
> Formula 1 checks if A>=5250.001 and B<=5000 then returns CIR2
> Formula 2 checks if A<=5000 then returns CIR1
> Formula 3 checks if A>=5250.001 and B>=5000.001 then returns OOC
>
> I can get all three formula working individually but I need them to work
> together as one formula, checking all three "ifs" and returning one of the
> three results.
>
> Can anyone help me with linking the three together or advise me if there is
> a better way to calculate this?
>
> Many thanks,
>
> Cheryl
>
>
>
>
>

Toppers,

Excellent thanks, I think I've tried every combination of the formula
except this one! Thanks for your help,

Cheryl

"Toppers" wrote:

> THIS ..?
>
> =IF(AND(A1>=5250.001,B1<=5000),"CIR2",IF(AND(A1>=5250.001,B1>=5000.001),"OCC",IF(A1<=5000,"CIR1","")))
>
>
> "Cheryl" wrote:
>
> > I am trying to create the following formula:
> >
> > I have two colums (A and B) with numbers.
> > Formula 1 checks if A>=5250.001 and B<=5000 then returns CIR2
> > Formula 2 checks if A<=5000 then returns CIR1
> > Formula 3 checks if A>=5250.001 and B>=5000.001 then returns OOC
> >
> > I can get all three formula working individually but I need them to work
> > together as one formula, checking all three "ifs" and returning one of the
> > three results.
> >
> > Can anyone help me with linking the three together or advise me if there is
> > a better way to calculate this?
> >
> > Many thanks,
> >
> > Cheryl
> >
> >
> >
> >
> >