View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pattid175
 
Posts: n/a
Default 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.