Subtracting
 

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

Subtracting
 

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

Subtracting
 

Much too easy. Thank you.


On Feb 17, 8:38 pm, "T. Valko" wrote:
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

Subtracting
 

You're welcome. Thanks for the feedback!

Biff

wrote in message
oups.com...
Much too easy. Thank you.


On Feb 17, 8:38 pm, "T. Valko" wrote:
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