give a 5% discount help needed please

ShirleyC

New Member
Joined
Sep 25, 2008
Messages
40
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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,090,108
Messages
5,412,460
Members
403,428
Latest member
ldmcd

This Week's Hot Topics

Top