klutz
09-17-2009, 10:10 AM
Hi,
I have this table with min and max amounts that requires a fixed amount when when the condition is met.
How do I write a formula for this. If result is >$0 but < $100 = $15 and so on...
I can't get it right..
Min Max Equals
$0 $100 = $15
$101 $200 = $20
$201 $1,000 = $ 30
$1,001 $3,500 = $50
$3,501 $10,000 = $75
$10,001 $50,000 = $120
$50,001 $100,000 = $180
$100,001 and over = $230
http://www.excelforum.com/images/misc/progress.gif
I have this table with min and max amounts that requires a fixed amount when when the condition is met.
How do I write a formula for this. If result is >$0 but < $100 = $15 and so on...
I can't get it right..
Min Max Equals
$0 $100 = $15
$101 $200 = $20
$201 $1,000 = $ 30
$1,001 $3,500 = $50
$3,501 $10,000 = $75
$10,001 $50,000 = $120
$50,001 $100,000 = $180
$100,001 and over = $230
http://www.excelforum.com/images/misc/progress.gif