Originally Posted by Jim Schnur

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.