Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
I need to calculate square footage totals...The dimensions are in a single
cell (example: 132 1/4 x 52 1/8). I know that width x height (calculated as inches) / 144 = square feet. Figuring a formula for this makes my head spin! Any help is appreciated. THANKS! :o) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
=LEFT(A1,FIND("x",A1,1)-2)*RIGHT(A1,FIND("x",A1,1)-2)/144
That is, if there is a space between the 1/4 and the x, and again between the x and the 5 in your example If there are no spaces, then change the first -2 to -1 -- HTH Kassie Replace xxx with hotmail "rmk101575" wrote: I need to calculate square footage totals...The dimensions are in a single cell (example: 132 1/4 x 52 1/8). I know that width x height (calculated as inches) / 144 = square feet. Figuring a formula for this makes my head spin! Any help is appreciated. THANKS! :o) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|