Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a complicated formula
THIS ..?
=IF(AND(A1=5250.001,B1<=5000),"CIR2",IF(AND(A1=5 250.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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a complicated formula
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,"CIR 1","")))) 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a complicated formula
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=5 250.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated formula please help asap! | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Creating a table from a formula | Excel Discussion (Misc queries) | |||
Complicated Formula | Excel Discussion (Misc queries) | |||
Creating a specific formula | New Users to Excel |