Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |