Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 570
  • Last Modified:

How to pull a formula from a table

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.
Converting-text-equation-to-exce.xlsx
0
kittycanine
Asked:
kittycanine
  • 2
  • 2
1 Solution
 
Dave BrettCommented:
Hi,

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

in the attached file I created a range name "Answer" that refers to
=EVALUATE(Calculation!$C$12)

Then in C13, typed
= Answer

Cheers
Dave


test.xls
0
 
kittycanineAuthor Commented:
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?
 
0
 
Dave BrettCommented:
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?

Cheers

Dave
0
 
kittycanineAuthor Commented:
solution performed the functin required.  However does not allow one to save in an xlsx format.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now