Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Percentages
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
showing percentages in pie charts | Charts and Charting in Excel | |||
Calculating Percentages with Variables | Excel Worksheet Functions | |||
Calculating percentages | Excel Worksheet Functions | |||
Excel percentages greater than 99% | Excel Discussion (Misc queries) | |||
Percentages error | Excel Discussion (Misc queries) |