I have a formula "=(IF((ISBLANK($J7)),0,(IF(ISTEXT($F7),(VLOOKUP(LE FT($F7,3),FTELookup,M$1,FALSE))*$J7,0))))-N7-M7" that I want to apply to cells in a column without placing the formula in each cell I want the formula to operate. My reason for the request is with the formula in each cell in the column row inserts take a good deal of processing time as does expanding an colapsing grouped column and rows. FTELookup is a function. Note that in the example formula J7 and F7 have a value where in some rows J and F are blank which would place a 0 in the cell. Any help will be greatly appreciated.

I have added an attachment with an example....

Cells I7 and I11 of my example contains the formula that I would like to apply to multiple cells in column "I" (and other columns) without pasting the formula in each of the cells (IE.. I7, I11, I15 and so on). I only want formula to calculate a value in cell I7 if there are values in cells A7 and B7 (and for rows 11, 15 and so on. I have pasted the formula into many cells in my spreadsheet and have found that processing of adding rows or expanding and colapsing groups takes a long time to complete. Again any help is greatly appreciated.