=MIN(100000,A1)*5.75+MAX(0,A1-100000)*5

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pam" wrote in message
...
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<10000
00),SUM(B30-100000)/1000*5+575)))