Excel Multiply Function

Question

I have a column of numbers (costs), call it Column L. I want the corresponding value in Column M to be the column L cost times .95.

I can create a formula for one cell at a time, but how do I expand that so that the formula applies to every row?

i.e M3 = L3*.95, M4=L4*.95, etc.

Thanks

Answer 1

If the formulas return zeros then I guess you have no data in Column L

Try this formula to hide the zeros until you get data in column L

=IF(L3="","",L3*0.95)   entered in M3 then drag/copy down as far as you need.

Gord

Answer 2

I am using Excel 2016, and when I do what you suggest, it populates the rest of the column as zeroes ($0.00).

Answer 3

Hi

When you select cell M3, the cell border turns darker with a dot in the bottom right corner. Set your mouse cursor on the dot and double click.

Answer 4

When I Double Click on M3, I get zeroes all the way down the Column. The formula does not carry over.

Answer 5

In M3 enter =L3*.95

Double-click on M3 and the formula will be copied down as far as there is data in L

The progressive cell addresses will be automatic.

Gord