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.

Assuming you enter your number in Cell A1, this is your formula that you
can enter in, say, Cell B1:

=0.78*A1

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=500256

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.