Quote:
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.
|
You can't have the results of a formula populate a cell without the formula actually being in that cell.
Am I missing the point of what you're trying to do here??
Perhaps an example workbook with a bit more of an explanation would help.
Similar Threads
Threaded Mode
