Lets say I have several formulas that I need to invoke in a cell. Which formula to be used to evaluate the cell is dependent on the result of an additional conditional formula. Is there a way to place these several evaluation formulas in an external array and call for them based on the result of the conditional formula. For example:
C1 is =IF(D1>E1,[formula in B1 invoked on D1],[formula in B2 invoked on D1:E1])
A B 1 ROUND(__) 2 SUM(__)
Bookmarks