×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Convert square inches to square feet
5

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?  

RE: Convert square inches to square feet

And what does the 116.25 have to with conversion to sq. ft.?


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

12 inches to a foot, 12 squared =144

What else do you need?

RE: Convert square inches to square feet

Assuming Sq inches in cell B1 and you want sq ft in cell C1.

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

or =ceiling(C1/166.25,1)

RE: Convert square inches to square feet

Or, if you want to complicate things,
=CONVERT(CONVERT(A1,"in","ft"),"in","ft")
Maybe someone can develop a custom visual basic function to really complicate things.openup

RE: Convert square inches to square feet

Is convert() in an add in pack for excel or is it a different spreadsheet?
Or are you just being humorous?
 

RE: Convert square inches to square feet

From Excel 2003 help for CONVERT...

"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

After reading the OP, I have today become a supporter of the FE exam.

RE: Convert square inches to square feet

You are confusing me!   

Never, but never question engineer's judgement

RE: Convert square inches to square feet

Hey XxTwobonexX:

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

the round function only rounds to the nearest integer ... it doesn't round up (3.1 becomes 3).

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

the ceiling function does round up and the floor function rounds down.  Both will round to whatever number of significant digits you need, or to an integer.

RE: Convert square inches to square feet

Quote:

I still don't think I understand the original question.
Which brings us to KiwiMace's April 18 post.

RE: Convert square inches to square feet

I think that the answer to the original question is to use ROUNDUP function which can be to positive or negative numbers.

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

What I understand is that you want a formula to round-up a number.
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

42

RE: Convert square inches to square feet

Well we've finally arrived at "The Ultimate answer to Life, the Universe and Everything" and we still don't know what the orginal post from "XxTWOBONExX (Structural)" wants to know.  I think our work is done here.......

noevil

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources