| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a combo box to calculate percentages in Excel?
Spreadsheet has a series of columns --
Column A (Salary), Column B (employer contribution), Column C (employee contribution containing 11 different perentages), Column D (total contribution -- equals B & C) The combo box has a list of percentages to calculate a total for column C, but I can't get it to work. What formula or macro do I need to use? I am using Excel 2000. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get a combo box to calculate percentages in Excel?
In Column D you can use your formula something like =B1*C1 depending on how you have written your values for your percentages or =B1+(B1*C1) -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=535324 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get a combo box to calculate percentages in Excel?
Are you using a combo box from the controll tool box or are you using a drop down list from data validation, Maybe you could use a lookup formula instead if you wanted the percentages to calculate automatically, what would your conditions be -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=535324 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get a combo box to calculate percentages in Excel?
I'm using a combo box from the control tool box, which has to be used because
this part is a homework assignment. I've been trying to get this to work for 5 days now. The formulas for cell B and C are independent of each other, but the sum total would be in column D. "davesexcel" wrote: Are you using a combo box from the controll tool box or are you using a drop down list from data validation, Maybe you could use a lookup formula instead if you wanted the percentages to calculate automatically, what would your conditions be -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=535324 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get a combo box to calculate percentages in Excel?
What isn't working.... -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=535324 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Getting Excel to Calculate All Combinations of a Set of Data? | Excel Worksheet Functions | |||
| Is it possible to calculate integrals with Excel? | Excel Worksheet Functions | |||
| how to calculate overtime automatically on Excel timesheets | Excel Worksheet Functions | |||
| PivotTables in Excel 2004 calculate incorrect standard deviations | Excel Worksheet Functions | |||
Linear Mode
