| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert room dimensions 13' 8" X 9' 2" to square feet
On Thursday, July 28, 2011 5:41:59 AM UTC+5:30, isabelle wrote:
hi Dale, this doesn't exist in the native functionality of Excel, i suggest you a custom function with provided that data is always enter in that form (0'1") or (10'12") =SquareFeet(A1,B1) Code:
Function SquareFeet(rng1 As Range, rng2 As Range) As Double x = Split(rng1, "'") inches1 = CDbl(Application.Substitute(x(1), """", "")) feet1 = CDbl(x(0)) x2 = Split(rng2, "'") inches2 = CDbl(Application.Substitute(x(1), """", "")) feet2 = CDbl(x(0)) SquareFeet = ((feet1 + (inches1 / 12)) * (feet2 + (inches2 / 12))) End Function -- isabelle isabelle please u ahev video for this excel sheet convert for square feet, i wait of ur reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert column with inches to 2 columns "feet" and "inches" | Excel Discussion (Misc queries) | |||
| Convert Square Feet to Gallons | Excel Worksheet Functions | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
Threaded Mode
