Help getting 2 formulas into one
 

I am trying to write a formula that covers these conditions:

If B2 = FF00 and (G2< -50,000 or G2 50,000)
Or
If B2= BE00 and (G2< -50,000 or G2 50,000)
Or
If B2= LU00 and (G2< -50,000 or G2 50,000)

Then return €œManual€� otherwise leave the cell blank.


Right now I have two separate cells doing the calcs. One for determining
whether B2 is FF00, BE00 or LU00 and another cell that determines if it is
50,000 or < -50,000. Ive tried several different iterations of formulas but
Im getting confused with nesting IF AND & OR functions.

This is what I have in I2
=IF(OR(B2="FF00",B2="BE00",B2="LU00"),"UC","")

And this is what I have in J2
=IF(AND(I2="UC",G250000),"Manual",IF(AND(I2="UC", G2<-50000),"Manual",""))

Can anyone help me get this into one formula?

Thanks

Help getting 2 formulas into one
 

On Wed, 29 Jul 2009 12:58:01 -0700, Iriemon
wrote:

I am trying to write a formula that covers these conditions:

If B2 = FF00 and (G2< -50,000 or G2 50,000)
Or
If B2= BE00 and (G2< -50,000 or G2 50,000)
Or
If B2= LU00 and (G2< -50,000 or G2 50,000)

Then return “Manual” otherwise leave the cell blank.


Right now I have two separate cells doing the calcs. One for determining
whether B2 is FF00, BE00 or LU00 and another cell that determines if it is
50,000 or < -50,000. I’ve tried several different iterations of formulas but
I’m getting confused with nesting IF AND & OR functions.

This is what I have in I2
=IF(OR(B2="FF00",B2="BE00",B2="LU00"),"UC","")

And this is what I have in J2
=IF(AND(I2="UC",G250000),"Manual",IF(AND(I2="UC" ,G2<-50000),"Manual",""))

Can anyone help me get this into one formula?

Thanks


Try this formula:

=IF(AND(OR(B2="FF00",B2="BE00",B2="LU00"),OR(G2<-50000,G250000)),"Manual","")

Hope this helps / Lars-Åke

Help getting 2 formulas into one
 

Try This


=IF(AND(OR(C3<-50000,C350000),OR(B3="BE00",B3="FE00",B3="LU00")) ,"Manual","")

--
Best regards

Rajesh Mehmi






"Iriemon" wrote in message
...
I am trying to write a formula that covers these conditions:

If B2 = FF00 and (G2< -50,000 or G2 50,000)
Or
If B2= BE00 and (G2< -50,000 or G2 50,000)
Or
If B2= LU00 and (G2< -50,000 or G2 50,000)

Then return "Manual" otherwise leave the cell blank.


Right now I have two separate cells doing the calcs. One for determining
whether B2 is FF00, BE00 or LU00 and another cell that determines if it is

50,000 or < -50,000. I've tried several different iterations of formulas
but
I'm getting confused with nesting IF AND & OR functions.

This is what I have in I2
=IF(OR(B2="FF00",B2="BE00",B2="LU00"),"UC","")

And this is what I have in J2
=IF(AND(I2="UC",G250000),"Manual",IF(AND(I2="UC", G2<-50000),"Manual",""))

Can anyone help me get this into one formula?

Thanks