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?

you need ot get some VBA for excel the best is to use a funtion in a
particulas cell and make a statement that on click the cell will
display the result.

I will need more information or the sheet to explain



I got a lot of my begginer help on this site... cool

www.MDOTutorials.com


--
Route2391
------------------------------------------------------------------------
Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774
View this thread: http://www.excelforum.com/showthread...hreadid=399586