Re: how do i get to discount 10% of a bill

On 30 Aug, 20:08, dermot martin cleary <dermot martin
cle...@xxxxxxxxxxxxxxxxxxxxxxxxx> 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


.

Relevant Pages

  • Re: Limit a sum using discounts
    ... Don't forget, if the cell is formatted as a percentage, it should only ... > At the moment the sum looks for G24 where the discount can be set eg 40%, ... >>>I am trying to cap a cell that I use for discounts. ...
    (microsoft.public.excel.misc)
  • Re: Limit a sum using discounts
    ... At the moment the sum looks for G24 where the discount can be set eg 40%, ... I was thinking of using a hidden cell in certain rows where a product can ... > remove caps from email ...
    (microsoft.public.excel.misc)
  • Re: Help on SUMIF please!
    ... You could also use SUMIF like ... discount it and display the sum of the other values.' ... > I have tried using SUMIF but cannot get the cell to display correctly, ...
    (microsoft.public.excel.newusers)
  • Re: Conditional format; if statement
    ... calculation in another cell? ... Cell B1 thru B6 calculate a total. ... (sum of the column ends up ... in B7) I want to be able to incorporate a discount by typing the discount ...
    (microsoft.public.excel.worksheet.functions)
  • Help on SUMIF please!
    ... discount it and display the sum of the other values.' ... I have tried using SUMIF but cannot get the cell to display correctly, ...
    (microsoft.public.excel.newusers)