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