View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KevinM KevinM is offline
external usenet poster
 
Posts: 9
Default 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