Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Caculating multiple percents in a worksheet
Hello,
Using Excel 2003, what is the formula I would use to accomodate the automatic calculation of multiple percents within the same worksheet? For example, if I needed to know what both 6% and also 9% as below? Subtotal % of Subtotal Total added to % of Subtotal 10 + 25 = 35 6% 37.1 15 + 26 = 41 15% 47.15 Thanks, Paula |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Caculating multiple percents in a worksheet
Hi Paula,
We're going to need more info. Where is 9%? What does 35 6% 37.1 mean? Are they in different cells? How does 6% of 35 equal 37.1? Where did 15% come from? -- Thanks, Shane Devenshire "Paula" wrote: Hello, Using Excel 2003, what is the formula I would use to accomodate the automatic calculation of multiple percents within the same worksheet? For example, if I needed to know what both 6% and also 9% as below? Subtotal % of Subtotal Total added to % of Subtotal 10 + 25 = 35 6% 37.1 15 + 26 = 41 15% 47.15 Thanks, Paula |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Caculating multiple percents in a worksheet
Perhaps using a one variable data table would easily cover your intents to
calculate multiple outputs for the range of multiple input percentages ? Try this sample whcih illustrates: http://www.freefilehosting.net/download/3ae0b Using a one var data table for multiple inputs-outputs.xls Assume the single variable is the percentage input in D2, and the output is calculated in E2, where E2 in this instance, contains the formula: =C2*(1+D2) [C2 is assumed a constant here] Here's a quick way to set-up a one variable data table in an adjacent area on the same sheet Put in H2: =E2 (just a simple link to the output cell in E2) List the range of possible percentages in say, G3:G18 eg input in G3:G18 : 5%, 6%, ... 20% Select G2:H18, then click Data Table Leave row input cell blank Enter in column input cell: D2 Click OK. That's it. H3:H18 will return the results corresponding to the percentages in G3:G18. You can change the input percentages in G3:G18 if you so wish, H3:H18 will recalc accordingly. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Paula" wrote: Hello, Using Excel 2003, what is the formula I would use to accomodate the automatic calculation of multiple percents within the same worksheet? For example, if I needed to know what both 6% and also 9% as below? Subtotal % of Subtotal Total added to % of Subtotal 10 + 25 = 35 6% 37.1 15 + 26 = 41 15% 47.15 Thanks, Paula |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Caculating multiple percents in a worksheet
Helo Shane,
I think I am trying to figure out how to write a conditional statement? For example, for the name of each specific company I type in a cell, I want their assigned % rate to automatically appear. For example, if "Smith" then 10% if "Brown" then 15% - so the % rate for each company will automatically fill in when I type the company's name. How do I associate a specific % value with each different company, so I don't have have to type it in for each one manually? Thanks Paula "ShaneDevenshire" wrote: Hi Paula, We're going to need more info. Where is 9%? What does 35 6% 37.1 mean? Are they in different cells? How does 6% of 35 equal 37.1? Where did 15% come from? -- Thanks, Shane Devenshire "Paula" wrote: Hello, Using Excel 2003, what is the formula I would use to accomodate the automatic calculation of multiple percents within the same worksheet? For example, if I needed to know what both 6% and also 9% as below? Subtotal % of Subtotal Total added to % of Subtotal 10 + 25 = 35 6% 37.1 15 + 26 = 41 15% 47.15 Thanks, Paula |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Caculating multiple percents in a worksheet
Based on your clarification, a vlookup comes to mind ..
Assuming in B2 down would be: Smith, Brown, etc you could use something like this in say, C2: =IF(B2="","",VLOOKUP(B2,{"Smith",0.1;"Brown",0.15} ,2,0)) with C2 formatted as percentage. Copy C2 down Alternatively, simpler, assuming placed in say, Sheet1's C2: =IF(B2="","",VLOOKUP(B2,Sheet2!A:B,2,0)) where Sheet2's cols A & B houses your vlookup reference table, names in col A, percentages in col B -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Paula" wrote: I think I am trying to figure out how to write a conditional statement? For example, for the name of each specific company I type in a cell, I want their assigned % rate to automatically appear. For example, if "Smith" then 10% if "Brown" then 15% - so the % rate for each company will automatically fill in when I type the company's name. How do I associate a specific % value with each different company, so I don't have have to type it in for each one manually? Thanks Paula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook not caculating formulas | Excel Discussion (Misc queries) | |||
Percents and Text in one cell - need to add percents only | Excel Discussion (Misc queries) | |||
Counts/Percents Multiple Criteria | Excel Worksheet Functions | |||
Caculating Columns Between Certain Dates | New Users to Excel | |||
Caculating a "staircase" discount | Excel Worksheet Functions |