tags:

views:

18

answers:

1
+1  Q: 

Evaluate string as formula in cell in Excel 2007

Hello. I haven't had any luck finding an eval-type function to use in a cell for Excel.

Let's say I have a cell A1 that contains string "C4". I'd like to be able to write an in-cell function similar to this IF(EVAL(A1)>10,"TOO BIG","TOO SMALL"). That would then effectively be C4>10 for the expression.

Is this possible without VBA?

+1  A: 

If I understand correctly the problem the solution would be:

IF(EVAL(INDIRECT(A1))>10,"TOO BIG","TOO SMALL")
momobo  2010-08-02 06:43:56
Perfect! Thanks!
mouche  2010-08-02 17:25:31

related questions

Restricting eval() to a narrow scope
How to rescue an eval in Ruby?
in c#: expression evaluation function like flash script
instantiate a class from a variable in PHP?
How to invoke classes dynamically without using eval?
Repeater's SeparatorTemplate with Eval
How can I work around the fact that I can't put a code block in a skin file?
Does threading behaviour of eval() vary across different browsers?
Wordpress Category ID vs Eval Issue
Php and macros(lisp style)?
PHP's create_function() versus just using eval()
Why does my script report 'uninitialized value in eval "string"?
Setting variables by name in Java
<%# Eval("State") %> or <%# DataBinder.Eval(Container.DataItem, "state")%>
How to use Single Quotes in Eval Format String
Escaping dilemma in Javascript.
In PHP, is there a way to capture the output of a PHP file into a variable without using output buffering?
Creating a lambda from an s-expression
Are Dynamic Prepared Statements Bad? (with php + mysqli)
When is JavaScript's eval() not evil?
Eval scripts in server side control property
What is the scope for imported classes in python?
Why is using Javascript eval function a bad idea?
Best Technique for Multiple Eval Fields in Gridview ItemTemplate?
How can I evaluate a C# expression dynamically?