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