percentage:how to do this?

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

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

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


--
Regards

Roger Govier


"Supersaint" <Supersaint@discussions.microsoft.com> wrote in message
news:C113F7D3-31E3-4F04-9DBD-75C3F9A1588F@microsoft.com...
>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.