Hi

Put the percentage require in say cell Di as 22%, then in B1
=A1*(1-$D$1)
Copy down as required.
Altering the percentage value in D1 will automatically adjust all other
cells.


--
Regards

Roger Govier


"Supersaint" wrote in message
...
I want to put a number into one cell, allow a formula to minus 22%,
then
display the result in an adjacent cell. Can anyone tell me how to do
this
please.
Many thanks.