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.

In Apple Numbers I want a cell to have 4x8x7 (or 4*8*7) to show the detail of the volume, and in another cell I want that volume calculated 4*8*7=224 based on the first cell. But it doesn't consider the first cell as an operation. Which formula can help ?

share|improve this question

2 Answers 2

You could use the string concatenation operator '&' and make a formula like this:

=B2&" X "&B3&" X "&B4 which would display "4 X 8 X 7"

then have another formula that actually calculates the function:

=B2*B3*B4 which would display "224"

http://i.imgur.com/9ggakhc.png

share|improve this answer
    
I was working on a convoluted formula with multiple SEARCH and MID functions, then realized this was a far more straightforward approach. –  ghoppe Feb 19 '13 at 22:15
    
I would have to fill 3 more cells manually, something I would rather avoid having to do –  user2113 Feb 20 '13 at 11:51
up vote 0 down vote accepted

I was given this answer on another website:
put =4*8*7 in the first cell, set it to text format, duplicate it and set it to automatic format so that it calculates the result

share|improve this answer

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.