convert to feet and inches

[sjl]

if i have a value such as 1.9878 and want to show it to the nearest feet and
inches how would i do it?

 

[macropod]

Hi,

Depends on what you're trying to convert. Nautical miles, yards, metres, leagues?

I suspect metres, in which case you could use:
=INT(A1/0.3048)&"ft "&ROUND((A1/0.3048-INT(A1/0.3048))*12,0)&"in"

Cheers

--
macropod
[MVP - Microsoft Word]


| if i have a value such as 1.9878 and want to show it to the nearest feet and
| inches how would i do it?
|
|

 

[Bernard Liengme]

But if 1.9878 is in feet, then format the sell with custom format # ??/12 to
see 2
And 15.56 shows as 15 7/12


If 1.9878 is metres and is in A1 then =A1/0.038 with the same custom format
show 52 4/12

In all cases, the values are numeric and you can do math on them.

best wishes

 

[daddylonglegs]

Hello macropod, in some circumstances, e.g. when A1 = 1.82 the result of your
suggested formula will be "5ft 12in". To always get "6ft 0in" try

=INT(ROUND(A1/0.0254,0)/12)&"ft "&MOD(ROUND(A1/0.0254,0),12)&"in"