Creating a complicated formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
THIS ..?

=IF(AND(A1>=5250.001,B1<=5000),"CIR2",IF(AND(A1>=5250.001,B1>=5000.001),"OCC",IF(A1<=5000,"CIR1","")))
 
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,"CIR1",""))))

Vaya con Dios,
Chuck, CABGx3
 
Toppers,

Excellent thanks, I think I've tried every combination of the formula
except this one! Thanks for your help,

Cheryl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
How do I weave in "date" information to my formulas? 2
With F1 value, look at A, if match or partial match return B 5
IF AND Nested Functions - Formula Not Working 0
Lookup Across Multiple Rows / Columns 5
How to weave in Date Information please? 4
Searching the formula (not the value) for a text string 1
IF formula for currency or Macro help. 0

Back
Top