Hi
I need to display volume in one column and the answer in another column.

example 2x3x3 18
(display only) (answer)

How can I do it.
Any help is highly appreciated
Thanks

I assume that you're talking about the volume of a cuboid?

The easiest way might be to enter your dimensions in 3 cells (such as A2,
B2, C2), then you can get your results with
=A2&"x"&B2&"x"&C2 for the display cell, and
=A2*B2*C2 for the calculation.
--
David Biddulph

"vs" wrote in message
...
Hi
I need to display volume in one column and the answer in another column.

example 2x3x3 18
(display only) (answer)

How can I do it.
Any help is highly appreciated
Thanks

Hi

Assuming your entries for the 2x3x3 are to be in column A.
InsertNameDefine
Name Volume
Refers to =EVALUATE(SUBSTITUTE($A1,"x","*"))

In B1 enter
=IF(A1="","",Volume)
Copy down column B as far as required
--
Regards

Roger Govier


"vs" wrote in message
...
Hi
I need to display volume in one column and the answer in another
column.

example 2x3x3 18
(display only) (answer)

How can I do it.
Any help is highly appreciated
Thanks

vs,

Putting all three dimensions in one cell isn't the best way for a spreadsheet. If you put
them in separate columns, the formula would be simply:
=B2 * C2 * D2

If they're already in the worksheet in that fashion, you can use Data - Text to columns to
separate them.

If you must keep them in one cell separated by "x", then use:
=LEFT(A2,FIND("x",A2)-1)*MID(A2,FIND("x",A2)+1,FIND("x",A2,LEFT(A2,FIND( "x",A2)-1)+1)-FIND("x",A2)-1)*RIGHT(A2,LEN(A2)-FIND("x",A2,LEFT(A2,FIND("x",A2)-1)+1))

See what I mean? Someone may come up with a more concise (but probably still difficult)
formula to handle it, but I recommend the first approach.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"vs" wrote in message
...
Hi
I need to display volume in one column and the answer in another column.

example 2x3x3 18
(display only) (answer)

How can I do it.
Any help is highly appreciated
Thanks