Nested Formula Help
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
|