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