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

On 30 Aug, 20:08, dermot martin cleary <dermot martin
wrote:
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 ?.

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

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
DTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"dermot martin cleary" <dermot martin
wrote in message ...
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 ?.

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(D41,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.

"dermot martin cleary" wrote:

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