How do I get a combo box to calculate percentages in Excel?

P

Pattid175

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.
 
D

davesexcel

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)
 
D

davesexcel

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
 
P

Pattid175

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
Adding sequence numbers to paragraphs 0
Getting a formula to reflect added columns 10
How to center adjust text above and image in a two column document. 1
Creating a Search using a combo box and then creating a report. 4
Sum of values in column A based on 0/1 of column B 2
Copying formulas across columns 2
Need to get minimum difference 1

Top