Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Value
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Value
Thank you for the response but do you have a very simple example in which i
can build upon since my experience with excell is limited? "Don Guillett" wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Value
Hi,
The math doesn't seem right. $300-50%=$150 is ok $600-30%=$180 is not ok. Should be 420? If $300 is in A2, then in B2: =A2-(A2*50/100) If $^00 is in A3, then in B3: =A3-(A3*30/100) If you really want 50% of 300 and 30% of 600: in B2: =A2*50% in B3: =A3*30% Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|