volume formula display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi

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

In B1 enter
=IF(A1="","",Volume)
Copy down column B as far as required
 
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...
 
Back
Top