Auto-Copy Formulas

jdougherty19146

I was having some problems with standard =this+that*something formula not copying down when I add a row. When I add an IF() statement to the formula, it seems to work. I noticed this, because all of the IF statements in other columns were working, so I thought I'd test the theory (add the IF()), and it worked. Anyone else have a problem with this?

Find more posts tagged with

Non-profit

Formulas

Project Management

Comments

Mike Wilday

Were you getting errors? What specifically was the issue?

Kara Lumley

Hi there -

I was not able to replicate this. Did you have at least two rows above the newly inserted row that contained the formula?

Did you have numbers in the other columns for the formulas to reference?

Best,

Kara

Marcus Odum

Have you tested the "insert below" function? When right clicking on a row this function is the second option. It usually inherits formulas and formatting from the selected row.