percentage

S

Supersaint

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.
 
B

BenjieLop

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

=0.78*A1

Regards.
 
R

Roger Govier

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.
 
Top