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(__)
You probably need code unless there are only a few formulas when you can use IF functions or equivalent. Depending on what the functions are you may also be able to use SUBTOTAL or AGGREGATE
Josie
if at first you don't succeed try doing it the way your wife told you to
Trying to avoid code at present.
Example was oversimplification. Called formulas would perform lookup or similar functions, not math operations.
Then you will require nested IF functions or similar-you can use XLM functions but that's basically code
That's the impression I had.
Was also searching the web about this type of functionality and came acroos something called "morefunc" add-in that adds among others, a formula() function to Excel. Has any body tried it? Comments? Recommendations?
It has an EVAL function that will probably work if you can use an add-in (not clear why that's better than code for you?)
the sample uses named range then
refers to: =evaluate()
maybe.xlsm
file should be saved as macro enabled.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
I see that performs the example I gave, but I can't figure out how to implement that functionality into my "real" file. Perhaps you can explain, say starting with a blank xlsx workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks