views:

18

answers:

1

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
Perfect! Thanks!
mouche