Home |
Search |
Today's Posts |
#1
|
|||
|
|||
command button
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|