Forum Discussion
Square Footage Cell(s) Worksheet
OK: I've given you one possible solution (not knowing for sure what you meant for column E to display, I made it the cell that computes the square footage based on width and length) and I've created this using inches for width and length, to give you greater precision. Here's the formula.
=(C7/12)*(D7/12)
I'm attaching the revised spreadsheet. As you'll see, I modified slightly your "Document Size" line. It now looks like this:
OK: I've given you one possible solution (not knowing for sure what you meant for column E to display, I made it the cell that computes the square footage based on width and length) and I've created this using inches for width and length, to give you greater precision. Here's the formula.
=(C7/12)*(D7/12)
I'm attaching the revised spreadsheet. As you'll see, I modified slightly your "Document Size" line. It now looks like this:
- =((B3*12)+(IFERROR(D3/E3,0))+C3)*((F3*12)+G3+(IFERROR(H3/I3,0)))/144
B & F = Feet, C & G = Inches, D & H = numerator of a fraction, E & I Equals the denominator of a fraction So 10 ft. 8 1/2 in. will look like | 10 | 8 | 1 | 2 | in the first 4 cell of your spreadsheet. the IFERROR will null out any DIV/0! error if there are no numbers in D & H or E & I. - Thank You
- You are welcome!
