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

Pattid175 · 04-23-2006, 10:35 AM

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.

**davesexcel** · 04-23-2006, 10:49 AM

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** · 04-23-2006, 10:56 AM

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

Pattid175 · 04-23-2006, 11:15 AM

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