MS Excel help

dragon2309

dragon2309

P.I Dragon
I need an Excel expert, lol, or at leats someione who knws what they are doing. Heres the problem:

I have to make a spreadsheet where the user can select either 1, 2 or 3 hour driving lesson and then select their driving tier (level of the lesson). This is easily done with combo boxes you say, well, yes it is, and i get it to put the selections on a different sheet etc.... BUT heres the tricky part, obviously to work out the total cost tyou need o multiply the two variables together, simple, yeh, next, the number of hours is ok cos its already a number. Its the lesson tier im struggling on.

Basically, there are 4 options to this tiering, if you select the first one, it will pront a "1" in the cell and so on, but i dont want it to be a 1, i want it i=to be something like 15, cos it costs £15 per hour.

This is done with a lookup table, simple again, done that bit. Next, there are discounts for users, if they book a 2 hour lesson they get a discount of £1 and a 3 hour lesson gets a £2 discount, now im stuck, really stuck, and its due in in a couple of days for ICT coursework, please PLEASE help me....


dragon2309

:eek:
 
You can use if statements in EXCEL.

Example: =IF(A6=1,2,3)
So if Cell A6 = 1 the cell with the function will have a value of 2, else it will be 3.

So the combo box will point to A6.... if they select a 2 hour lesson, A6=2, and subtract 2 from the total cost.. etc...
 
well then, you need to pick up a Microsoft Excel for Dummies book...

...and the first topic you need to learn about is the "IF statement"
 
the if statement is like this:
=if(criteria,true statement, false statement)

so whatever you put in the criteria is what is tested. if the test comes out true, it returns the true statement, if it is not true, it returns the false statement.

using the previous example

=IF(A6=1,2,3)

in plain english that is like this
if the value in A6 is equal to 1, the return the value 2, else return the value 3.
 
You must log in or register to reply here.
Back
Top