How to pull a formula from a table

Posted on 2009-12-17
Last Modified: 2012-06-27
I have several tables of formula equations as part of a design code.  Based on various paraters, the formula to be used to calculate a value of a cell will be based on an equation read from a specific table, row and column.  Because of the shear number of formulas that  can be used, I can not use IF statements.  Currently I can get my sheet to read the text equation and display the text equation properly.  I can even get the equation to show cell address or cell values for the variables.  But what I can not figure out is how to get excel to actually evaluate equation.   If there a way to achive this without using VBA code.  I have attached an example of what I am trying to achive.  Let me know if you require further information.  I believe in all my formulas that I will be dealing with variables do not show up more than once.
Question by:kittycanine
    LVL 50

    Accepted Solution


    You can do this using a defined name, that uses XLM

    in the attached file I created a range name "Answer" that refers to

    Then in C13, typed
    = Answer


    LVL 3

    Author Comment

    Sweet! works very nice and has the exact name for what I was looking to do. I only have one problem, and I probably used the wrong terminology in my poorly spelt and punctuated original question. The reason I was asking for a solution with out VBA is that I am trying to save in an xlsx format which prohibits macros and VB. When I try to do this with your solution I get an error that states an Excel 4.0 function stored in defined names.  Is there an alternate solution that will allow me to save as an xlsx file type?
    LVL 50

    Expert Comment

    by:Dave Brett
    Your question was put fine. :)

    I had thought that the XLM warning may be ok, as long as it wasn't VBA that did require macros. It sounds like this will be an issue?


    LVL 3

    Author Closing Comment

    solution performed the functin required.  However does not allow one to save in an xlsx format.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now