Excel 2007 : IF and AND funtion

Hello :D

Well my problem is that i have an assignment to do but i cannot find the correct formula for this. In my scenario it says:

As each vehicle has a specific cost to hire per day, the receptionist has to look up this cost, and then multiply it by the number of days it is being hired for. If the customer is hiring the vehicle for more than 7 days, the customer gets a 3.5% discount. VAT (17.5%) is also added to the sub-total. This then all added up to give the grand total.

Could you please help me ?

Thanks.

Normally with homework assignments we're happy to advise, without doing the work for you......what have you tried so far?

Lool..

Ermm well i have tried to make do the formula but i just can't make it. I don't know what the formula for adding a pourcentage is and the teacher hasn't told us that either.

Please could anyone help me ...

1st step is to create the math formula on a piece of paper to clearly understand what you need to do

OK, I'll start you off.......

Adding or subtracting a percentage is just basic maths.

If you want to give a 3.5% discount then you just multiply the price by 100% minus the discount

A French poet said
"What is understood well is stated clearly
And the words to say it come esaily..."

( free translation)

well, how would you calculate percentage without excel ?
work that out first then do it in excel

Thanks for the reply :D

Will it be like this then : =SUM(Price*100%-3.5) ?

Beware that XL has a priority in calculations
Multiplication comes before soustraction !

Thanks for your replies

Could i not do this formula : =SUM(Price*1.3.50)

Lool im a bit noob in maths :x

Have you read Martin's post?