Convert square inches to square feet 5

[XxTWOBONExX]

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?

 

[IRstuff]

What other formula are you refering to, other than the one you gave?

TTFN

FAQ731-376

 

[IRstuff]

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

 

[csd72]

12 inches to a foot, 12 squared =144

What else do you need?

 

[blutfort]

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)

 

[cvg]

or =ceiling(C1/166.25,1)

 

[Clyde38]

I have no idea what you are trying to do.
But it is Friday....
See attached spreadsheet.

 

[jghrist]

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.

 

[blutfort]

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

 

[EGT01]

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

 

[KiwiMace]

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

 

[COEngineeer]

You are confusing me!

Never, but never question engineer's judgement

 

[trainguy]

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

 

[rb1957]

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

 

[cvg]

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.

 

[HgTX]

I still don't think I understand the original question.

Hg

Eng-Tips policies: faq731-376

 

[jghrist]

I still don't think I understand the original question.

Which brings us to KiwiMace's April 18 post.

 

[StephenA]

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

http://www.landandmarine.com

 

[HgTX]

But but but...how can you tell what the original question is?

Hg


Eng-Tips policies: faq731-376

 

[mexicali8]

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