Subtracting

G

goldcomac

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
 
T

T. Valko

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: Edit>Copy
Select the cells you want decreased by 5%
Then: Edit>Paste Special>Multiply>OK
Clear the cell of the 0.95

Biff
 
G

goldcomac

Much too easy. Thank you.


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: Edit>Copy
Select the cells you want decreased by 5%
Then: Edit>Paste Special>Multiply>OK
Clear the cell of the 0.95

Biff
Click to expand...
 
Top