MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Formula only


Posted by Christina O'Neill on September 17, 2001 7:01 AM

I'm creating a spreadsheet to track when employee evaluations are due, based on the employee's start date. I have the formulas written for row 1, the first entry, but want to copy the formula only for the next 99 lines, without having an entry. Two things: when I copy the formula cells, it calculates against the empty data in the referenced cells. Also, if I copy entire rows, and ask to copy formula only, it's copying everything, text and all. Is there anyway that I can copy a formula without having it calculate against empty cells?


Posted by brent on September 17, 2001 8:48 AM

Supposing that your "start date" column is A and your formula column is B: with heading; row one begins in cell $A$2 and your first row formula is in $B$2;
A2 9/15/01
B2 =IF(ISNUMBER(A2),"your formula","")