Multiply by 0.95

You can do it to a range of cells all at once if the values are constants.

Enter 0.95 in an empty cell
Copy that cell: EditCopy
Select the cells you want decreased by 5%
Then: EditPaste SpecialMultiplyOK
Clear the cell of the 0.95

Biff

wrote in message
oups.com...
I know how to add 5% to a cell (=cell *1.05) but I don't know how to
subtract 5%.

Cell A1 = 100
Cell A2 = 90

How do I write the formula to get that answer?

Thanks.

Chip