Data in A2:A1000
In cell B1 put 50%
In cell B2 put =A2*(1-$B$2) and copy the formula down - 50% discount
Put 25% in cell B1 and you get 25% discount etc
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Sharon" wrote in message
...
I have a colum listing over 600 products. I need to make an additional
colum reducing the cost of these products by different percentages, 50%,
25%,
etc. I can do this by changing each, one by one. Does anyone know the
formula that I can use that when entered will do the whole column at
once.
Thanks, Sharon
|