开发者

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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜