Formula converting inches to sq feet
I am new to using Numbers. I would like to enter height and width in inches and two separate columns. And have the third column display the total square feet.
Is that possible?
iPad Pro, iPadOS 17
Question marked as
And if you want to be explicit in what you want to be calculated (which can be useful if you share the spreadsheet), you could use the formula (using the same cell references as @Badunit):
= CONVERT(B2 * C2, "in2", "ft2")
Where "in2" stands for inch square and "ft2" for foot square.
Or this formula:
= CONVERT(B2, "in", "ft") * CONVERT(C2, "in", "ft")
