OK, for those true Excel power users this will be easy, but it's driving me crazy.

I have a table and each cell has a dollar value inside. All I want to do is reduce ALL dollar amounts by 32.5% (*.675). I know this is easy, I just never use this program.

I guess I need to select a cell range and *.675. But how?

Can anyone help? (Excel XP/2002 BTW)

 

Maybe not the easiest way but certainly not very difficult...

Can't you just create a duplicate sheet, then link the duplicate to the original. Link the first cell in the table (ex - =Sheet!A1*0.675) then copy and paste that formula to all the other cells. If you wanted, you could then copy the table and paste values to remove the links.

 

A1 contains $$
B1 type in =A1*0.675
Select cells B1 to B###
CTRL-D

 

Actually, if you want to drop the price by 67.5%, you would need to multiply the orignal price my 32.5%.

 

True, I want to drop the price by 32.5% Thanks for noticing that....more coffee for me.

 

type in .675 in an empty cell.. copy it... select the cells you want to change go edit>paste special>multiply.. then tada!