Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help!
I have four columns in my worksheet that I need help resolving. Is it
possible to for excel to accomplish the following: first Column, "I" (in x in = SQ FT) In cell I:206 I have the equation exactly as; 030'' x 048'' Can excel calculate and put the answer 10 in J:206? Second Column, "M" (mm x mm = M2) In cell M:205 I have the equation exactly as; 0406 x 0889 Can excel calculate and put the answer .36 in J:206? Third Column, "Q" (in x in x Ft = FBM) In cell Q:18 I have the equation exactly as; 06'' x 08'' x 16' Can excel calculate and put the answer 5.3 in R:18? Fourth Column, "U" (mm x mm x m =M3) In cell U:28 I have the equation exactly as; 191 x 191 x 4.9 Can excel calculate and put the answer .04 in V:28? Or, is de-concatenate necessary first to arrive at the calculations? Thank you in advance for your help. -- Kimberlie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help!
Hi Kimberlie,
One of the MVP's may disagree with me, but I think you have some work ahead of you. I would use EDIT, REPLACE to change all the x's for nothing, then do it again to replace all the " with nothing, and do it again for any other extraneous symbols you have in the cells. Once you just have numbers and spaces, you can use Text to Columns to de-concatenate (parse) the data. From there you can perform the maths you want. Sorry I can't be more helpful Regards - Dave. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help!
With those particular entries, put these formulae in the cells stated:
J206: =LEFT(I206,3)*MID(I206,9,3)/144 N205: =ROUND(LEFT(M205,4)*RIGHT(M205,4)/1000000,2) R18: =ROUND(LEFT(Q18,2)*MID(Q18,8,2)*MID(Q18,15,2)/144,1) V28: =ROUND(LEFT(U28,3)*MID(U28,7,3)*MID(U28,13,3)/1000000,2) Here's what I got: J206 = 10, N205 = 0.36, R18 = 5.3, V28 = 0.18. The last one differs from your example, but does check out with a calculator. Hope this helps. Pete On Apr 30, 7:00*pm, Kimberlie wrote: I have four columns in my worksheet that I need help resolving. Is it possible to for excel to accomplish the following: first Column, "I" (in x in = SQ FT) In cell I:206 I have the equation exactly as; 030'' x 048'' Can excel calculate and put the answer 10 in J:206? Second Column, "M" (mm x mm = M2) In cell M:205 I have the equation exactly as; 0406 x 0889 Can excel calculate and put the answer .36 in J:206? Third Column, "Q" (in x in x Ft = FBM) In cell Q:18 I have the equation exactly as; 06'' x 08'' x 16' Can excel calculate and put the answer 5.3 in R:18? Fourth Column, "U" (mm x mm x m =M3) In cell U:28 I have the equation exactly as; 191 x 191 x 4.9 Can excel calculate and put the answer .04 in V:28? Or, is de-concatenate necessary first to arrive at the calculations? Thank you in advance for your help. -- Kimberlie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|