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