Announcement

Collapse
No announcement yet.

Convert Decimals To Feet & Inches

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Re: My Forumula Is Too Long For One Cell

    Originally posted by Aaron Blood
    LOL!
    .

    Comment


    • #17
      Re: My Forumula Is Too Long For One Cell

      Thanks everyone for the help!

      I was able to get both Froojam's and ByTheCringe2's formulas to work. I did have to add a round function to both formulas to hold my 4 decimal place limit but they both work great.

      Now im off to dissect both formulas to figure out how ya did it so i can learn a little more. haha

      Thanks again all!

      Comment


      • #18
        Re: My Forumula Is Too Long For One Cell

        Your original set of formulas would need such a round function too.
        .

        Comment


        • #19
          Re: My Forumula Is Too Long For One Cell

          Have a look at CONVERT functions.

          =IF(MOD(CONVERT(MOD(A11,1),"ft","in"),1)*16>=15.5,((MOD(CONVERT(MOD(A11,1),"ft","in"),1)*16)+INT(CONVERT(MOD(A11,1),"ft","in")))/100+INT(A11),(((MOD(CONVERT(MOD(A11,1),"ft","in"),1)*16)/10000)+(INT(CONVERT(MOD(A11,1),"ft","in"))/100)+INT(A11)))
          Last edited by Krishnakumar; November 17th, 2006, 14:10.
          Kris

          ExcelFox

          Comment

          Working...
          X