Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |