Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I have a cell with the following content 2262/4121. I want to have a cell next to it that contains the result of that expression. Is there a function for that?

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

You can use the VALUE() function for that. Its only argument is the cell that you want to evaluate.

share|improve this answer
    
On the spot. Thank you a bunch. –  Fork Oct 9 '11 at 14:09
    
It only works if the source text cell contains a mathematical expression in the form of "a/b". Any other operator such as +-* fails. Also multiple operands such as "a+b+c-d+e-f+g" are not possible. I would like to have my source text cell with i.e. "1+2+3-4+5-6.7+8.99" and another cell evaluating the content of that source cell. –  porg Jun 26 '13 at 19:58
    
Anyone with a solution for evaluating a cell with multiple arbitrary operands? –  porg Apr 30 at 15:00
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.