Percentage calculation
 

I'm trying to adjust fixed numbers in cell's 'A' & 'B' with a number I'm
inputting in cell 'C'.
(eg, Cell 'A' has a value of $100.00. I want to decrease this value by a
percentage I'm inputting in Cell 'C'. Cell 'B' has a value of $150.00. Again,
I'm trying to decrease this number with a percentage in Cell 'D').
I'm sure this is MS Excel 101...........any help would be appreciated.
--
Many Thanks,
Mike

Percentage calculation
 

In E1 enter =A1*(1-C1) and copy down the column
In F1 enter =B1*(1-D1) and copy down the column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mmacnz" wrote in message
...
I'm trying to adjust fixed numbers in cell's 'A' & 'B' with a number I'm
inputting in cell 'C'.
(eg, Cell 'A' has a value of $100.00. I want to decrease this value by a
percentage I'm inputting in Cell 'C'. Cell 'B' has a value of $150.00.
Again,
I'm trying to decrease this number with a percentage in Cell 'D').
I'm sure this is MS Excel 101...........any help would be appreciated.
--
Many Thanks,
Mike

Percentage calculation
 

I must be doing something wrong - didn't work.
The numbers in Columns 'A' & 'B' were not changed when I entered a value in
colums 'C' & 'D'. Again, I just want to decrease the values in 'A' & 'B' with
a percentage in cell's 'C' & 'D'.

Many Thanks,
Mike


"Bernard Liengme" wrote:

In E1 enter =A1*(1-C1) and copy down the column
In F1 enter =B1*(1-D1) and copy down the column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mmacnz" wrote in message
...
I'm trying to adjust fixed numbers in cell's 'A' & 'B' with a number I'm
inputting in cell 'C'.
(eg, Cell 'A' has a value of $100.00. I want to decrease this value by a
percentage I'm inputting in Cell 'C'. Cell 'B' has a value of $150.00.
Again,
I'm trying to decrease this number with a percentage in Cell 'D').
I'm sure this is MS Excel 101...........any help would be appreciated.
--
Many Thanks,
Mike

Percentage calculation
 

On Oct 21, 7:08 pm, mmacnz wrote:
I must be doing something wrong - didn't work.
The numbers in Columns 'A' & 'B' were not changed when
I entered a value in colums 'C' & 'D'. Again, I just want to
decrease the values in 'A' & 'B' with a percentage in cell's
'C' & 'D'.

When you enter the "percentage" in columns C and D, do you enter, for
example, 0.05 or 5% (either is correct) or 5 (which is not really a
percentage)?

I'm guessing the latter. In that case, you could fudge the formulas
to accommodate the form of your "percentage". For example:

=A1*(1-C1/100)

But I think it is more reliable for you to correct the form. You can
enter literally 5%, or you can enter 0.05 and be sure use Format -
Cell - Number to select Percentage with the desired decimal places.