=(A1<"")*MIN(A1,4999999)*5%+MAX(0,A1-4999999)*10%+MAX(0,A1-9999999)*15%
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"KevinM" wrote:

I am trying to write a formula that will take the total contract value
and times it by the assoicated percentage.

$1-$4,999,999 = 5%
$5,000,000 - $9,999,999 = 10%
$10,000,000+ = 15%

If the contract value is $6,000,000, than it would do ($4,999,999*5%)+
($1,000,001*10%)=$350,000.05