| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert Function
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") |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Convert Function
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") |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Convert Function
You're welcome. Thanks for the feedback!
Biff "jayceejay" wrote in message ... 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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| How do I use Excel's convert function for apothecary weight? | Excel Worksheet Functions | |||
Linear Mode
