View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
acss acss is offline
external usenet poster
 
Posts: 38
Default Formula for Value

I am working on various cells that are repetitive. I have two countries which
have a total amount but need a percentage subtracted.

brazil total $300-50percent =$150
china total $600-30 percent=$180.00
How do i set up a formula based the value of brazil or china in which the
the total for brazil will be reduced by the fixed percentage of 50 percent or
for china by 30 percent?