How about this:

=A2-(A2*A1)

HTH
Elkar


"spudsnruf" wrote:

Hello,

Assume cell A1 has the % of discount I need to offer. (say 5%)
Assume cell A2 has the gross amount before a discount is calculated...(say
£100)
and I just want the net amount (ie after disccount in cell A1 is applied) to
be in cell A3

What should the formula in cell A3 look like (to result in £95) Sure this is
easy for many...but its got me beaten. I know I can just put a formula of
0.95*A2. But thats not what I wnat to, as I will need to change the actual
value in A1 frequently, and dont want to have to change the foumala each time
I make that change.

Thank you very much