Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentages
can some one please help before i go insane
i'm trying to work out cost using percentage what i want to do is... a1 charge b1 cost b2 % i want a sum to work out what the charge is if cost is 100 and % is 30 i need the sum because % changes for each item cheers confused deejay x -- deejay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentages
If Cost is in B1 and percentage in B2
Then this in A1 =B1*(1+B2) will give you the Charge So if B1 is 100 and B2 is 30% then Charge would be 130. Is that what you were looking for? If not then pl. give the values in B1 and B2 and the expected value in A1. "confused deejay" wrote: can some one please help before i go insane i'm trying to work out cost using percentage what i want to do is... a1 charge b1 cost b2 % i want a sum to work out what the charge is if cost is 100 and % is 30 i need the sum because % changes for each item cheers confused deejay x -- deejay |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentages
Please give us what values are where and what needs to be worked upon.
-- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "confused deejay" wrote: can some one please help before i go insane i'm trying to work out cost using percentage what i want to do is... a1 charge b1 cost b2 % i want a sum to work out what the charge is if cost is 100 and % is 30 i need the sum because % changes for each item cheers confused deejay x -- deejay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PERCENTAGES | Excel Worksheet Functions | |||
percentages | New Users to Excel | |||
percentages | Excel Discussion (Misc queries) | |||
Percentages | Excel Discussion (Misc queries) | |||
Percentages | Charts and Charting in Excel |