The title line of this post probably doesn't make much sense. I couldn't figure out how to explain what I need in that short space. I'm wondering if it's possible to write a formala that if a certain condition is met, performs a formula referenced in another cell. For example:
Column A contains a list of formulas. In column B is the condition, let's use Work Type as an example. The result (or the formula I need) would be in column C.
So if the work type is "Type1", then the formula in the corresponding column C cell would perform the formula in cell A5.
If the work type is "Type8", then the formula in the corresponding column C cell would perform the formula in cell A2.
Is this possible to do without VBA?
Bookmarks