View original (French)

Excel formula with a discount in %.

Solved
Thierry -  
 kriss -
Hello,

I am looking for the formula to apply in Excel to calculate with a percentage discount

example: €10 - 5%

waiting for your response
Thierry
Configuration: Windows XP Internet Explorer 7.0

1 answer

  1.
    chtilou Posted messages 1704 Status Member 523
     
    Hello Thierry,
    For calculating the 5% discount 
    =(A1*5)/100

    For calculating the discounted price 
    =A1-(A1*5)/100
    290
    1. sana
       
      Thank you
      0
    2. yo
       
      thank you
      0