IF formula

B

BARRIOSWJ

Let's try this again!
This is what I want to do.

I want a cell to put the following

If E2 (contains the invoice amount) is between $0 and $50 put "$0 -
$50.00" in the cell.
If E2 is between $50.01 - $100 put "$50 -$100"
If E2 is between $100.01 - $500 put "$100 - $500"
If E2 is between $500.01 - $1000.00 put $500 - $1000"
And if it's over $1000.01 then put "1000+"

How do I make this into a formula?
 
W

William Horton

Is this what you are looking for ???

=IF(AND(E2>=0,E2<=50),"$0 - $50.00",IF(AND(E2>=50.01,E2<=100),"$50.01 -
$100",IF(AND(E2>=100.01,E2<=500),"$100.01 -
$500",IF(AND(E2>=500.01,E2<=1000),"$500.01 -
$1,000.00",IF(E2>=1000.01,"1,000+","Other")))))
 

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

if value is between two numbers 6
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Making a macro only work on certain files 2
Want To Shrink Formula 1
Newbie Help - IF Yes No Function 0
Payment calculation 1
Hate DBL post but I really need help 0
If Multiple Criteria 1

Top