Formulas and Calculations

dennis.goudy72296

O.K.  I have now inserted my formula to calculate a number of miles driven for a given trip.  But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of row 1 and drag it down to copy the formula into the other rows but it puts a zero in those blank rows. 

 

 

Andrée Starå

Hi Dennis,

To fill the formula down you can also use:

• Another quick way to fill content down a column is to use the keyboard shortcut Ctrl + D (Windows) or Command + D (Mac).

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

You can add an IF statement before your formula.

=IF(ISBLANK([Ending Miles]@row), "", PUT in the REST OF YOUR FORMULA without the equal sign)

I am assuming Ending Miles is the name of the column.