volume formula display
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 |
volume formula display
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 |
volume formula display
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 |
volume formula display
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 |
All times are GMT +1. The time now is 07:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com