Percentage calculation

[Guest]

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.

 

[Bernard Liengme]

In E1 enter =A1*(1-C1) and copy down the column
In F1 enter =B1*(1-D1) and copy down the column
best wishes

 

[Guest]

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

In E1 enter =A1*(1-C1) and copy down the column
In F1 enter =B1*(1-D1) and copy down the column
best wishes

 

[joeu2004]

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.