command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top