command button:. how can i create a command button

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?

I would just use an IF statement within an IF statement.
Roughly like
=IF(DropDownCell="apprentice1",$10,(=IF(DropDownCell="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?