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:
Your description is helpful; far more helpful would be to show us the spreadsheet as it is (even though, ore maybe especially because, it's not working as desired).
From what you've written it sounds like you're entering in cell C6 something like 2.5x3.
Is it possible to write a formula that parses 2.5x3 and converts it to 7.5? Yes.
But it isn't straight forward--it involves text manipulation, extracting the sub-parts of that whole entry into individual components and determining the value of each sub-part. It's possible, but as you've discovered (apparently, if I'm reading your posting accurately) not intuitive.
My suggestion would be that you enter the 2.5 in cell C6; then enter 3 in cell D6
And this simple formula in E6: =C6*D6
If this doesn't resolve your concern, please post a copy of the worksheet you've created so far so we can see the actual.
