formula discount

  • Thread starter Thread starter Guest
  • Start date Start date
"Discount" can mean a lot of things. One meaning would be to give an x%
discount on a base value. If the base value is in A1 and you want to
apply a 10% discount:

B1: =A1 * (1 - 10%)

or, equivalently

B1: =A1 * 90%

"need formula as soon as posible" <need formula as soon as
 
Or are talking about the DISC worksheet function. You can find the help
on your machine for this function.


Mangesh
 
Whatever formulae you end up using I would suggest that the discount rate
"variable" is in a separate cell to which the formula refers. In this way
you need only change the discount rate once. The alternative is to change
all the formulae at the risk of missing one!

Regards.

Bill Ridgeway
Computer Solutions

"need formula as soon as posible" <need formula as soon as
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top