# formula to convert inches to square foot

1. ## formula to convert inches to square foot

I need a formula to automatically convert inches to square feet.
I have =IF(G5>12,G5/144)
and G5 is the cell used to enter your inch value. The formula wrks great, but only if you enter over 12 inches. I'm pretty sure Im on the right track, just need to know how to add in the part about if its less than 12 inches it should be multiplied by 12.

2. If G5 is in square inches, square feet is G5/144. There's no need to test the value first.

3. I know.
I use the formula: =IF(G5>12,G5/144)
If i put the number 14 into the cell G5 it works great. But enter 8.5 and it gives me FALSE.
So.....
I change the overal formula to: =IF(G5<12,G5/12)
Then I can enter a number under 12 and it will calculate it correctly.
My question again is-How do I combine the two formulas so that I can enter either number and have it calculate the result in square feet.

4. Just =G5/144

5. hmmmm....nutin' like feeling stupid.
I guess maybe I was thinking it should be harder than that?

6. We all get blind spots.

If that sorts it, would you please mark the thread as solved?

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

If more than two days have elapsed since your first post, ask a moderator to mark it.

7. ## Re: formula to convert inches to square foot

I am an excel newbee 100% when it comes to creating formulas. And when i found this thread i delighted.

In col A cell 1 i want to convert my measurements 17 inches widith multiplied 53 inches length and would like to say equals 20 sq ft.(not the correct answer just an example) in col B cell 1.

Can anyone help me out?

Cheers!

There are currently 1 users browsing this thread. (0 members and 1 guests)