View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
mmacnz mmacnz is offline
external usenet poster
 
Posts: 3
Default 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