Forum Discussion
Square Footage Cell(s) Worksheet
Good Day,
I am constructing a Pricing Worksheet. And one component is for Oversized Poster printing. To which calculating (sq. ft.) is necessary.
So I want to able to enter my dimensions (y'x z') in cell C6. and from there having the conversion show in cell D13. I either haven't put together the correct formula or is it truly not possible to run sq. ft. conversions in separa
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.
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:
- Thank You
This is just play so do not take it too seriously. I have created a mix of standard Excel dynamic array formulas with a sprinkling of RegEx. I am sure a hardcore regular expression expert would not approve but breaking down the cryptic expressions to their constituent parts helps me!
(values in blue are input data)
Worksheet formulae
= AreaCalc(width, length) "for a single occurrence, or" = MAP(width, length, AreaCalc) "for a list of dimensions"where the Lambda function is defined to be
/* "Function Name: AreaCalc"*/ /**"Calculates an area from the width and length expressed in feet and inches" */ AreaCalc = LAMBDA(length1, length2, LET( number, "[\d|\/|\.|\s]+", f, "[\'|f]", in, "[\""|in]", PosLkAhd, LAMBDA(t, "(?=" & t & ")"), feet, number & PosLkAhd(f), inches, number & PosLkAhd(in), measure1, IFNA(REGEXEXTRACT(length1, HSTACK(feet, inches)), 0), measure2, IFNA(REGEXEXTRACT(length2, HSTACK(feet, inches)), 0), area, (SUM({12, 1} * (measure1)) * SUM({12, 1} * (measure2))) / 144, ROUND(area, 2) ) )
