I
Iriemon
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",G2>50000),"Manual",IF(AND(I2="UC",G2<-50000),"Manual",""))
Can anyone help me get this into one formula?
Thanks
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",G2>50000),"Manual",IF(AND(I2="UC",G2<-50000),"Manual",""))
Can anyone help me get this into one formula?
Thanks