Convert square inches to square feet
Convert square inches to square feet
(OP)
Howdy,
This is what i am trying to do
300inches x 96 inches = 28800 sq in
218 inches x 96 inches = 20736 sq in
28800+20736=49536 sq in
49536 sq in convert to sq feet=344sq ft
344 sq ft / 116.25=2.95914
Round up=3
Is there a formula?
This is what i am trying to do
300inches x 96 inches = 28800 sq in
218 inches x 96 inches = 20736 sq in
28800+20736=49536 sq in
49536 sq in convert to sq feet=344sq ft
344 sq ft / 116.25=2.95914
Round up=3
Is there a formula?





RE: Convert square inches to square feet
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Convert square inches to square feet
For that matter, your calculator appears to be broken: 218*96 = 20928, not 20736
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Convert square inches to square feet
What else do you need?
RE: Convert square inches to square feet
Formula for Cell C1 is:
=B1/144
If you also want to then divide by the secret number 116.25 (?Bags of Jelly Beans / Sq ft?)
Cell D1 is then
=ROUNDUP(C1/116.25) or =INT(C1/116.25+.999)
RE: Convert square inches to square feet
RE: Convert square inches to square feet
But it is Friday....
See attached spreadsheet.
RE: Convert square inches to square feet
=CONVERT(CONVERT(A1,"in","ft"),"in","ft")
Maybe someone can develop a custom visual basic function to really complicate things.
RE: Convert square inches to square feet
Or are you just being humorous?
RE: Convert square inches to square feet
"If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in."
RE: Convert square inches to square feet
RE: Convert square inches to square feet
Never, but never question engineer's judgement
RE: Convert square inches to square feet
In cell A1, enter value 300
In cell A2, enter value 218
In cell A3, enter value 96
In cell A4, enter 116.25 (whatever this is...)
Then, in another cell, enter the formula:
=ROUND((((A1*A3)+(A2*A3))/144/A4),0)
I personally wouldn't use a single formula for this, it makes it hard to troubleshoot, but everybody has their own style...
tg
RE: Convert square inches to square feet
with my limited knowledge of excel i'd calculate the formula in one cell, A5, (so i can see the result) and then
INT(A5)+1
RE: Convert square inches to square feet
RE: Convert square inches to square feet
Hg
Eng-Tips policies: FAQ731-376: Eng-Tips.com Forum Policies
RE: Convert square inches to square feet
RE: Convert square inches to square feet
eg ROUNDUP(123.456,-2) gives 200, whereas ROUNDUP(123.456,2) gives 123.46.
Stephen Argles
Land & Marine
www.landandmarine.com
RE: Convert square inches to square feet
Hg
Eng-Tips policies: FAQ731-376: Eng-Tips.com Forum Policies
RE: Convert square inches to square feet
In Excel you can use the function
=ceiling(number to be rounded-up, unit to be rounded-up to)
Example
=ceiling(344/116.25,0); it rounds-up to 0 or multiples of 0.
=ceiling(344/116.25,1);it rounds-up to 1 or multiples of 1.
=ceiling(344/116.25,3.75); it rounds-up to 3.75 or multiples of 3.75
RE: Convert square inches to square feet
Well, I was just being graphical when I said multiples of 0.
RE: Convert square inches to square feet
Now here at my office everyone set his computer in the search for multiples of 0.
They even are thinking in an array of computers to do so.
RE: Convert square inches to square feet
RE: Convert square inches to square feet