Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Page 2 of 2 FirstFirst 1 2
Results 11 to 19 of 19

Thread: Convert Decimals To Feet & Inches

  1. #11
    Join Date
    27th January 2003
    Location
    Swindon, England
    Posts
    116

    Re: My Forumula Is Too Long For One Cell

    I'd agree with that. Having your output formula in column B before the other columns that helped you arrive at the answer threw me a bit too.

    I'd be tempted to just move column B to the end and then hide the other columns too.

    Sometimes it makes more sense to break the formula down in to smaller parts than to have it in one, unwieldy formula anyway. At least then someone other than yourself would have a CHANCE of understanding it !
    ________________

    Check out my band...
    http://www.myspace.com/suspicions
    facebook

  2. #12
    Join Date
    16th November 2006
    Posts
    71

    Re: My Forumula Is Too Long For One Cell

    Froojam

    I tried what you put but in some cases (depending on the input number) the result is more than 4 decimal places.


    If i add ROUND(Froojam'sFormula,4) to it, i belive it will work. Do you agree?

    Excel Video Tutorials / Excel Dashboards Reports


  3. #13
    Join Date
    16th November 2006
    Posts
    71

    Re: My Forumula Is Too Long For One Cell

    ByTheCringe2

    I do agree with you and Lee Armitage that i really should just keep the formula the way i have it and hide the columns but with the big picture in mind that i want to do on a worksheet, that would just cause a big mess i belive. That is why i am wanting to try to make it all fit in one cell.

    But i am very new to working with excell so i could be totally wrong.

    I do appreciate everyone's input so far!

    Excel Video Tutorials / Excel Dashboards Reports


  4. #14
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: My Forumula Is Too Long For One Cell

    Well, you asked for it!

    =IF(16*IF(MOD(A11,INT(A11))>=0.997395,MOD(A11,INT(A11)), (MOD(A11,INT(A11))*12) -INT(MOD(A11,INT(A11))*12))>=15.5,(16*IF(MOD(A11,INT(A11))>=0.997395,MOD(A11,INT(A11)),(MOD(A11,INT(A11))*12) -INT(MOD(A11,INT(A11))*12))+INT(IF(MOD(A11,INT(A11))>=0.997395,A11,MOD(A11,INT(A11))*12)))/100+INT(A11),(((16*IF(MOD(A11,INT(A11))>=0.997395,MOD(A11,INT(A11)),(MOD(A11,INT(A11))*12) -INT(MOD(A11,INT(A11))*12))/10000)+(INT(IF(MOD(A11,INT(A11))>=0.997395,A11,MOD(A11,INT(A11))*12))/100)+INT(A11))))
    Last edited by ByTheCringe2; November 17th, 2006 at 03:52.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #15
    Join Date
    10th February 2003
    Location
    Palm Beach, Florida
    Posts
    1,556

    Re: My Forumula Is Too Long For One Cell

    Sub All_Macros(Optional control As Variant)

  6. #16
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: My Forumula Is Too Long For One Cell

    Quote Originally Posted by Aaron Blood
    LOL!

    Excel Video Tutorials / Excel Dashboards Reports


  7. #17
    Join Date
    16th November 2006
    Posts
    71

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  8. #18
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: My Forumula Is Too Long For One Cell

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

    Excel Video Tutorials / Excel Dashboards Reports


  9. #19
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    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 at 14:10.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Convert Fractional Odds To Decimals
    By good2soft in forum Excel General
    Replies: 15
    Last Post: May 31st, 2007, 17:30
  2. Feet & Inches
    By rberger909 in forum Excel General
    Replies: 6
    Last Post: April 24th, 2007, 08:44
  3. convert decimals to fractions
    By [email protected] in forum TIP, TRICKS & CODE
    Replies: 7
    Last Post: August 5th, 2006, 21:45

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno