how do i get to discount 10% of a bill

[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 ?.

 

[Phil]

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

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

 

[Nick Hodge]

Dermot

you don't need the sum, but add *.9 at the end, e.g.

=(D4*F4)*.9

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog

 

[Guest]

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.