Conversions Of Decimal Feet To Decimal Inches - Formula?
Apr 15, 2012
I have to make a excel document in which I have length and width in feet and inch format.
E.g. 10.01 in which 10 is feet and .01 is inch
I have all the length and width values in the above format. And what I want to do is convert the inch value (10.01) to feet value (.01=.08 feet) .
Just like the calculator here does.. [URL] ........
Like
10.01=10.08
10.02=10.16
10..03=10.25
...and so on...
Here is table of conversions from inches to decimal feet. But I don't know how to get a formula for this in excel...????
Inch Decimal of a Foot
1 inch 0.0833
2 inches 0.167
3 inches 0.250
4 inches 0.333
5 inches 0.417
6 inches 0.500
7 inches 0.583
8 inches 0.667
9 inches 0.750
10 inches 0.833
11 inches 0.917
12 inches 1.000
View 7 Replies
ADVERTISEMENT
Nov 14, 2009
I often use feet and inch inputs for calulations. I prefer to input a typical feet & inch input into one cell using this format: ft-n.
example: 12ft 9in would input as 12-9
This would need to be converted into a decimal for calcualtions. Also I would like to convert from Decimal back to ft-in.
View 9 Replies
View Related
Dec 26, 2013
I need a formula to convert:
3.759 to 3' 9"
3.974 to 4'
4.005 to 4'
I have this currently:
=INT(D9)&"' "&ROUND(TEXT((D9-INT(D9))*12,"#"),0)&CHAR(34)
However, 3.974 returns 3' 12" and 4.005 returns a #VALUE error. I'm picky about the spaces. I'd like it formatted as I have it now.
View 3 Replies
View Related
May 18, 2011
I am currently working on cut sheets for my current project. I need to take my decimal feet (ie 1.55) and display them as feet and inches (1' 6 5/8") not (1' 6 3/5")
I have a formula which is this
=INT(F17)&"' "&TEXT(12*(F17-INT(F17)),"# #/#")&CHAR(34),
It works but the problem is the fractional inches 6 3/5" i need them to display in 1/8 1/4 1/2 when applicable. Is there something i could add to this formula to make my inches read like a measuring tape (1' 6 5/8") 1/8 1/4 1/2??? I attached the spreedsheet for review.
Question.xlsx‎
View 6 Replies
View Related
Feb 3, 2012
I am working in excel 2003 and I need to convert feet and inches into decimal feet. Example: 15'-10 5/8" to 15.88542
15'-10 5/8" will be in say, column B, and the conversion will be in say, column Q.
This formula will be copied all the way down the page.
how to do this or can it even be done in this version?
View 8 Replies
View Related
Feb 16, 2006
Is there a way to convert a value in a cell that is 2'-3 1/2" to adecimal such as 27.5"?
excel 2003 SP2
View 14 Replies
View Related
Jan 19, 2004
Is there a way to store a text style that will allow me to convert decimal numbers into feet and inches in the same cell?
I want to be able to type in a number like 3.5 and have it read 3'-6".
View 9 Replies
View Related
Feb 18, 2006
I am new to Excel but not programming and I am looking for a recommendation for the following. I have a spreadsheet that simply takes the length and width of an area and computes the square feet and yardage and other sundry items. I am entering the feet/inches as follows:
Example: 11.3 (equals 11/ft 3/inches)
The correct decimal conversion should be 11.25 but, obviously, it does not know that the number to the right of the decimal point is an indicator of inches. (ex.: .5=.42, .7=.58, .9=.75, .11=.92)
I have approached this from the stand point of an IF condition, finding the position of the "." and grabbing everything to the right (+1) but I understand that the limitation is 7 nested IFs.
Can someone get me kick-started on what the best approach would be to get my entry to convert to the true decimal equivalent? Currently, I am simply doing the conversion from memory but I would rather automate this sometimes errant approach.
View 9 Replies
View Related
Mar 24, 2009
This is a continuance of the Q and A below. Except the answer below converted a decimal like 1.44 to and answer like 1' 5.28".
except the final format I am after requires the 5.28" to be fractional such as:
1' - 5 1/4"
Is there a formula for this format?
View 9 Replies
View Related
Mar 3, 2014
believe this is a simple formula I just cant seem to get it right. Example: H1 has 859.375 and I need H2 to be 71' 7 3/8
View 5 Replies
View Related
Oct 28, 2008
Could someone please tell me what is wrong with this formula. I have been looking at it for so long, I can't even concentrate .....
View 9 Replies
View Related
Jun 23, 2008
I am working on a simple calculater, what I want to do is figure sq. inches my problem is every thing I try the decimals won't calculate right,, this is a example of what I want to do
8.25x10.75= 81 sq"
View 9 Replies
View Related
Jun 21, 2007
I am making an excel spreadsheet that auto fills in a lot of items for a construction company. One of the most important ones is the Roof Pitch.
1/12 pitch is 1 inch rise every 12 inches.
2/12 pitch is 2 inch rise every 12 inches.
I would like it to auto calculate this and add it to the over all height of the building.
Example:
A house is 20 feet wide with a 2/12 pitch.
Since the Ridge is in the center we divide the Width in half.
So a 2/12 pitch over a span of 10 feet is 20 inches
View 9 Replies
View Related
Aug 13, 2009
I have a vba macro that takes data from one workbook and pastes it into another workbook. In doing this I have declared a few variables of type single (I only need two decimal precision). However, when I copy the values from the cells on the source workbook and paste them into the target workbook, the numbers end up having 12 decimal places. Ultimately, this extra precision causes my totals to be off by .01 or more after a while. I have tried rounding the number as I pull it off the source workbook into the variable, but that didn't matter. How do I solve this problem? Code for pulling data from source workbook:...
View 2 Replies
View Related
Aug 3, 2006
Basically, I want to format a group of cells to display 1 decimal figure if the number is not a whole number. If the number is a whole number (or if the rounded first decimal place is 0) I want it to display no decimal.
View 9 Replies
View Related
Mar 29, 2007
I need to convert inches to feet and inches in this format:
88 1/2 = 7' 4-1/2"
...so that if 88 1/2 is in cell A1, cell B1 will show 7' 4-1/2".
The exact syntax of B1 must be as shown.
View 14 Replies
View Related
Jun 10, 2009
I need to convert a column of numbers currently formatted with 2 decimal places e.g. 112.12 to 4 decimal places (without the decimal point). I need the end result to be 1121200. I've tried a few different suggestions given on the forum previously but can't seem to retain the 4 decimal places that I require.
View 4 Replies
View Related
Aug 8, 2008
I am trying to create a unique sample code by putting together the values of other cells that a user will input. It's all working well apart from the last part, where I am trying to include a decimal number. I want the decimal number to appear without the central "." and in a four digit format. e.g. 2.5 would appear as 0250, 14.25 would appear as 1425. This is the formlua I am using currently:
=IF(ISBLANK(B4),"",IF(LEFT(C4,1)="w",(B4&"-"&TEXT(F4,"YYMMDD")&C4&TEXT(G4,"HHMM")),(B4&"-"&TEXT(F4,"YYMMDD")&C4&LEFT(TEXT(H4,"00"),2)&RIGHT(TEXT(H4,"00"),2))))
However, where the value of H4 is 2.5, I am getting a result of 0303 (I've put this part in bold). I have attached a small spreadsheet to aid understanding.
View 2 Replies
View Related
Mar 21, 2014
I am creating a spreadsheet for some deliveries. The pieces I have are all in feet and inches and multiplied by a certain quantity. I need a formula to run this and give me feet as an answer.
I have 4 cells, in A1 I have feet without the foot mark (20) and in cell B1 I have inches without the " (5). In cell C1 I have 20. How do I write a formula to do the following:
20'-5" multiplied by 20 = Answer in D1 408'
View 2 Replies
View Related
Mar 16, 2009
I am trying to calculate volume in inches then in feet using 2 methods to check my work.
Method ....
View 9 Replies
View Related
Nov 16, 2006
I need help shrinking down my formula to make it fit in one cell.
Right now, the way i have it, it spans across (7) different cells to get the results i desire. Is there a way i can make this shorter?
A11 – This is where the decimal value of a number is inputted.
B11 – This is the final display after running A11 through the formulas below
Here are my formulas: ...
View 9 Replies
View Related
Jun 10, 2007
I need a formula to multiply only the decimal number in a cell and not the integer. For example: the number in the cell is 57.3615. I want to multiply .3615 only.
View 2 Replies
View Related
Feb 27, 2014
I need a formula to take a number with several decimal places and round it up to two decimal places to either .33, .66 or, .00 if its above .66.
For example, 4.23423423423423 will be 4.33
4.43453453533434 will be 4.66
4.8353453453 will be 5.00
Lets say the number is in cell A1. What formula would do this?
View 3 Replies
View Related
Jun 1, 2009
I need to find a way to convert the fraction located at the beginning of a text string to decimals. Here is an example of what the cell containing the fraction will look like; 1/4-20 3A. I need to convert the fraction and save/copy paste the decimal answer to another cell.
View 3 Replies
View Related
Sep 19, 2006
My formula is not rounding properly. Cells I4, J4 and K4 all filter from the results of cell I3 divided by 3. (e.g. 10/3 = 3.333) I was able to remove the decimals in cells I1:K3, but the between formulas (I4:K4) keeps adding the decimal back, therefore this results in errors to my chart.
View 4 Replies
View Related
Jan 26, 2014
Is it possible to Conditionally Format using the (Custom) Data Validation Tool one or both of the following conditions:-
1. Force the user to enter the correct decimal point position for a given currency :-
The are 3 different decimal point locations location's - 0.87624 / 123.123 / 1273.00 There are always 6 numerals We have a table to lookup which specifies where the decimal point is on all currencies
CURRENCY AUDUSD< List is linked to a table
Price - High 0.87744< Decimal point dependant on chosen currency pair chosen
Price - Low 0.86596
Price - Close 0.86823
2. As above but numbers once entered will be formatted accordingly to the correct decimal place to the corresponding currency
View 12 Replies
View Related
Aug 22, 2009
If you look at the attached file in Column E line 47 you will see that it displays
373.97. However if you look in the formula bar it shows 373.9694. I am trying to make it so that the formula bar shows the same number as in the cell. Any idea on how to do this? I have tried everything I know how to do, which is not much.
View 4 Replies
View Related
May 26, 2009
i have lets say a table with rows that contain the following data.
SKU - PRICE - SALEPRICE - DESCRIPTION - SALEDESCRIPTION
What I am trying to do, is to make a concat formula that says:
SALEDESCRIPTION = DESCRIPTION+price was+PRICE+now+SALEPRICE
In essence so that i can simply pull down the formula, and all our product descriptions have 'special offer, was xx (price) is now xx (sale price).
This works fine, except that in the SALEDESCRIPTION, the amounts from the price and saleprice fields are being brought over without decimal places and without currency symbol.
I have tried formatting those two columns as currency or accounting but neither works.
View 4 Replies
View Related
Feb 18, 2014
This is my formula with concatenation: =K3/K1*100 & "c" & " Each"
This is the result of the values in K3 divided by K1: 6.41666666666667c Each
I would like to limit the decimal places to two: 6.41c Each.
I have tried to format the cell and none of the formatting options have any effect.
If possible I would like to use the rounding function but I do not know how to combine the formula + text + rounding.
View 9 Replies
View Related
Mar 5, 2009
I require a custom data validation formula to limit cell value to maximum of 4 decimal places.
0.0001 ok
0.02 ok
0.3 ok
0.12345 fail
0.123456 fail etc
View 2 Replies
View Related
