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: ...
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‎
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?
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
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.
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.
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
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'
I am trying to calculate volume in inches then in feet using 2 methods to check my work.
Method ....
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".
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.
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?
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
I am trying to convert Degrees Minutes & Decimals of a minute (12° 34.567') to Degrees and decimals of a degree (12.57611°). I have the formula to convert latitude, that is two digits, but it doesn't want to work with longitudes, three digits. (see attachment). This is the formula that I am using:
=IF(A2="","",(INT((LEFT(A2,3)+MID(A2,4,6)/60)*100000)/100000)&"d")
I need a formula to automatically convert inches to square feet. I have =IF(G5>12,G5/144). and G5 is the cell used to enter your inch value. The formula wrks great, but only if you enter over 12 inches. I'm pretty sure Im on the right track, just need to know how to add in the part about if its less than 12 inches it should be multiplied by 12.
View 5 Replies View RelatedHow, using PageSetup and xlPaperSize properties, to setup a custom paper size of 4 inches by 6 inches???
View 3 Replies View Related1.25 is in cell A1. This number will often be buried in a longer part number that may look like ELL-1.25-S40.
I would like to use a formula in cell A2 to display the fractional equivalent (1-1/4).
I have a spread sheet with over 200 numbers like 3.3, 4.5, 6.6 and so on. Is there and easy way to convert them to Percentages?
View 2 Replies View RelatedWhen exporting a set of historical sports results to Excel 2003 the numeric odds are converted to a date eg 7/2 changes to 07-Feb. Can this be prevented or adjusted to retain the original data.
Also if I may ask can the UK style odds be converted to a decimal style. Eg. 7/2 (UK) needs to be converted to 4.5 ( Decimal equivalent )
I have a list of numbers with decimals : such as
742111.37
703102.4
641771.52
652689.31
741202.92
I would like to convert the Numeric values to Text
Result :
Seven Hundred Forty Two Thousand One Hundred and Eleven and Thirty Seven .....
..........
..........
and so on....
I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction
for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")
and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8
But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?
I have a data set that expresses time in hours and minutes but it can only be exported like so:
7h10
11h03
Any function I could use to convert those numbers into 7.6 or 11.03?
I am creating a very quick holiday excel sheet where people can fill in the hours they want on which days.
I have a summery sheet too.
So if someone wants to take a full day which is 7.4 hours. How would this be represented as Hours and minutes?
I had a similar problem a day or two ago in converting Deg Min.dec to Deg.dec and it has happened again. This time I want to convert Degrees Minutes & Seconds to Degrees.decimals.
The formula I am using works for a two digit number Lat. but not 3 Long.?? Here it is below:
=+IF(A2<>"",INT((LEFT(A2,3)+MID(A2,4,2)/60+MID(A2,7,4)/3600)*100000)/100000&"d","")
I have 6 rows A1-A6(sheetsize), they can be 1 of 8 numbers. (16,14,12,10, 5/8, 1/2, 3/8, 3/16) these are all metal gauges. The cell next to them B1-B6(sheetgauge) has a number that refers to how much sq ft each of these sheet metal sizes has. I would like a cell below A30 to add up all the sq ft in B1-B6 if it is 16 gauge. Then A31 will add up all the 14 gauge, etc.
How is this possible without having a huge formula.
Here is my standard formula, but it wont add the B cells together if more than one of the same sheet sizes.
=index(sheetsize,match(A31,sheetgauge,0))
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.
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 RelatedI 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"
well in one of my excel reports, i am using a dsum formula and plotting a chart against it. i do not want to show the zeros on the graph, is there anyway i can do that, i could not find anything in the tools -> options.
View 2 Replies View RelatedI have a table set up that calculates feet and inches. My problem is that if I have an answer like 2'-0 3/8", it suppresses the zero. I tried setting the format up like ##"'" ##"''" ?/? with no luck.
View 2 Replies View Related