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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,089,675
Messages
5,409,659
Members
403,274
Latest member
Lewis1995

This Week's Hot Topics

Top