Convert Function
SLICK! Thanks Biff!
(Loved you in "Back to the Future")
"Biff" wrote:
Try this:
=IF(A1="","",IF(A1<12,"0' "&A1&"""",INT(A1/12)&"' "&MOD(A1,12)&""""))
A1 = 67
Returns: 5' 7"
I've written it so that if A1 is less than 1 foot the result will be like
this:
A1 = 7
Returns: 0' 7"
Biff
"jayceejay" wrote in message
...
I understand that there is a function (CONVERT) that converts feet to
inches
and vise-versa. BUT is there a modification of that function that will
convert inches to a COMBINATION of Feet and Inches? (ie: Convert a value
of
67 to 5'7")
|