I would just use an IF statement within an IF statement.
Roughly like
=IF(DropDownCell="apprentice1",$10,(=IF(DropDownCe ll="apprentice2",$15,$20))

Or take that drop down list and split it into three columns. Depending on
the math.

"ashley" wrote:

i'm trying to create a calculator that determines the rate of pay for an
apprentice, but am quite stuck. how can i create a command button that gives
me a calculation based upon three factors that are chosen from a drop down
list?