To allow for costs per 1000:

=MIN(100000,B30)*0.00575+MAX(0,(B30-100000))*0.005

"Toppers" wrote:

Try:

=IF(B30<1,0,IF(B30<=100000,(B30/1000)*5.75,IF(AND(B30=100001,B30<1000000),(B30-100000)/1000*5+575,"Call for quote")))

HTH

"Pam" wrote:

I have a formulat that is not working.
Basically I want a formula that will take up to $100,000 and multiply the
cost per thousand by $5.75
if the amount is over 100,000 to $1,000,000 I want it to take the first
100,000 and times it's cost per thousand by $5.75 and everything over that by
$5.00.
This is what I have came up with, but it is not working.
Then if it is $1,000,000.00 or more I would like it to say "call for quote"
any suggestions would be appreciated.
Thank you


=IF(B30<1,"0",IF(B30<=100000,SUM(B30/1000)*5.75,IF(B30=100001,AND(B30<1000000),SUM(B30-100000)/1000*5+575)))