a vlookup table for the countries and then something like

=b2*(1-vlookup(a2,tables!lookuptable,2))


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"acss" wrote in message
...
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?