command button

A

ashley

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?
 
M

Mike

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.
 
R

Route2391

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Help with Calculating Dates 1
New computer, how do i move outlook 365 ENTIRELY? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to implement two shifts per day with multiple teams 0
Counting cells that have a time 2
Formatting Rule: Diplay Section based on Selection in another section 0

Top