Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Convert Decimals To Feet & Inches

1. ## 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 !

2. Member
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. Member
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. Super Moderator
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. ## Re: My Forumula Is Too Long For One Cell

6. Super Moderator
Join Date
7th December 2005
Location
Hampshire, England
Posts
4,898

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

Originally Posted by Aaron Blood
LOL!

Excel Video Tutorials / Excel Dashboards Reports

7. Member
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. Super Moderator
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. Super Moderator
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.

##### Users Browsing this Thread

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

#### 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