square footage

[craigwojo]

Need to figure square footage for signs.
I know to multiply width x height = square footage. But I need a formula to do the following.

I am given the square footage I can use by the city for a sign and many times I know the height (or width) I can use. I need a cell to tell me the missing number.

Example:

Square Footage I can use is: 46 sqft. I know I only have 36" in height to work with. I need a cell to tell be what is the width I can make the sign to fill up 46 square feet.

Cell A1: input for square footage
Cell A2: input for the known measurement:
Cell A3: formula to figure the missing number to = A1.

Note: measurement are sometimes inches and sometime feet to work with. Mostly inches though.

Thank you and God bless,
Craig

 

[RSXchin]

height/46 = allowable width