K
Kimberlie
I have four columns in my Excel 2007 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.
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.