Need help with Calculations

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

Jim Thomlinson

The values that you have are currently stored as text. As such ther is no
direct way to calculate the totals as you have requested. So Yes you need to
split the cells out into their component measurements.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top