Another example: If you have cells named SubTotal and Tax, and type a formula =subtotal*tax Excel converts that to =SubTotal*Tax automatically. Because of this and because Excel puts functions in all ...
Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change. To simplify to process, use an absolute reference ...