how do i get to discount 10% of a bill

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

Guest

If someone is staying in a hotel for two nights @ €80 per night.I go
=sum(d4*f4)enter and get €160 how do i then give a 10% discount ?.
 
If someone is staying in a hotel for two nights @ €80 per night.Igo
=sum(d4*f4)enter and get €160 how do i then give a 10% discount?.
Click to expand...

Hi Dermot,

Well, for one thing, you don't need to use =SUM ....that only adds
things up. Assuming the room rate is in cell D4, and the number of
nights is in cell F4 (or the other way round), the formula for the
total is just =D4*F4.

To give them a 10% discount, try =(D4*F4)*90%

Hope that helps

Phil
 
And to build on what Nick and Phil offerend, if you don't offer the 10%
discount until a second night (i.e. no discount for one night stands <g>),
then assuming number of nights stay is in D4 with the rate in F4:

=IF(D4>1,D4*F4*.9,D4*F4)
You'll get D4*F4 for a one night stay, and
for anything longer than 1 night you'll get the discounted rate.
 
Back
Top