give a 5% discount help needed please

[ShirleyC]

I have a excel 2007 spreadsheet that works out a total of a customers order, how do I get it to give them a 5% discount.

so if their total in B29 = £423 I would like b30 to give me the amount with the 5% discount deducted.

Hope this make sense

thanks in advance

 

[sanrv1f]

=b29*95%

 

[ShirleyC]

Thank you so much, did not realise it was that easy :0)