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 ?
How to convert a chain into a number
numbers
Related Solutions
You can use a function to convert the duration to a plain number. For example, if difference between the dates in in E4, and it's 10 days, then...
=DUR2HOURS(E4) × 0.1
Shows a number, 24.0. There are other functions that you might use: DUR2DAYS, etc.
Changing the formula to =D1/24*8 does the trick.
Related Question
- How to get the current sheet name into the cell in Numbers.app
- How to copy a cell formula in Numbers
- How to convert a cell with a duration (datetime difference) to number in Numbers
- Directly input “duration” data type into Numbers formula
- How to sort rows in Numbers without affecting the formula
- How to add all of the text strings in all of the cells in a row together
- Range of values for a cell in Numbers
Best Answer
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