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)))