Evaluate string as formula in cell in Excel 2007
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?
If I understand correctly the problem the solution would be:
IF(INDIRECT(A1)>10,"TOO BIG","TOO SMALL")
精彩评论