Convert Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jayceejay - 18 Oct 2006 02:35 GMT

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")

Reply to this Message

Biff - 18 Oct 2006 02:53 GMT

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

>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")

Reply to this Message

jayceejay - 18 Oct 2006 03:05 GMT

SLICK! Thanks Biff!
(Loved you in "Back to the Future")

> Try this:
>
[quoted text clipped - 19 lines]
> > of
> > 67 to 5'7")

Reply to this Message

Biff - 18 Oct 2006 03:42 GMT

You're welcome. Thanks for the feedback!

Biff

> SLICK! Thanks Biff!
> (Loved you in "Back to the Future")
[quoted text clipped - 23 lines]
>> > of
>> > 67 to 5'7")

Reply to this Message