Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |