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
wrote in message
...
how to use formula discount? "%"