multiply of 2fit3inch and 4fit 3inch

  • Thread starter Thread starter brijesh
  • Start date Start date
B

brijesh

In Excel ,how we can multiply 2fit3inch and 4fit3inch .can u help me by any
function or any type??????
 
Try the below and once you get it how to work combine it to a single formula

Col A Col B Col C
Feet Inches In inches
2 3 =A2*12+B2
4 3 =A3*12+B3
=C2+C3
In cell C4 =c2+c3
=INT(C4/144) & " sq feet " & MOD(C4,144) & " inches"

PS: Also take a look at CONVERT() Converts a number from one measurement
system to another.. part of Analysis ToolPak add-in.

If this post helps click Yes
 
You must log in or register to reply here.

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

Similar Threads

Paste Special Formula Multiply feature doesn't work anymore 2
How can I create 6 3 x 3 inch squares in a page in word 2
How to multiply column and rows 13
Formula For Multiple Rows 2
IF formula 5
simple formula help in Excel 2007 2
constant multiplier 4
Column multiplied by a matrix 2

Back
Top