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")