Welcome to the Fraction Calculator. Please choose your fraction problem below.
Thanks to automatic image processing by PhotoStitcher, you can glue microscope shots together quickly and easily! How to Automatically Stitch Satellite Google Earth Images This tutorial answers a very common question: 'how to make a big image from multiple small satellite photographs. Express VPN Best for privacy. Number of IP addresses: 30,000 Number of servers: 3,000+ 3 months free with 1-year plan. So we have 2 times negative 5x is negative 10x. And then 2 times 8 is 16. So plus 16 is equal to negative 2. Now we have 10x minus 10x. Those guys cancel out. 10x minus 10x is equal to 0. So these guys cancel out. And we're just left with 16 equals negative 2, which is crazy. We know that 16 does not equal negative 2. This is an inconsistent. PhotoStitcher automatically aligns individual pictures stitching them one by one into an eye-catching professionally-looking panorama! People also like. Duplicate Photo Cleaner - Removes Duplicate Photos and Videos. Rated 4 out of 5 stars.
Thank you for using the Fraction Calculator to find and calculate fraction problems.Fraction Directory
For detailed instructions, step-by-step explanations, and solutions to all kinds of fraction problems, please see our directory.
Here are some examples of fraction problems that we have explained and answered:
Pie Chart of 2/3
What is half of 3/4?
What is the denominator of 7 as a repeating decimal?
What is a quarter of 1/4?
1/2 times what equals 1/2?
What divided by 1/4 equals 3/5?
What is 2 over 3 as a percentage?
How to calculate 3/4 plus 1/9
Is 1/2 greater than 1/3?
What is 4.56 as a fraction?
How to calculate 3/7 divided by 4/5
Equivalent Fractions of 3/9
What is the factorial of 6?
1/2 divided by what equals 3/4?
Reduce 5/25
What times 1/3 equals 1/2?
1/3 minus what equals 1/5?
4/9 Rounded to the Nearest Hundredth
What is 1/4 of 1/2?
3/4 Rounded to the Nearest Tenth
What is 4/5 as a decimal?
50/24 Rounded to the Nearest Whole Number
3/4 plus what equals 4/5?
Greatest Common Factor (GCF) of 2, 4 and 6
What is 3/2 as a Mixed Number?
Least Common Denominator (LCD) of 3, 9, and 20
What is 1 3/4 as a Decimal?
What plus 3/4 equals 2/5?
5 5/6 as a Percent
2 3/4 Rounded to the Nearest Half
What is 9 3/4 as an Improper Fraction?
3 3/4 Rounded to the Nearest Whole Number
How to calculate 5/6 times 3/2
What is the Quotient of 6/9?
What is the remainder of 4/5?
What is 48/52 simplified?
How to calculate 4/5 minus 3/4
How to Write 5/9 in Words
What minus 1/4 equals 1/3?
Copyright | Privacy Policy | Disclaimer | Contact
What divided by 1/4 equals 3/5?
What is 2 over 3 as a percentage?
How to calculate 3/4 plus 1/9
Is 1/2 greater than 1/3?
What is 4.56 as a fraction?
How to calculate 3/7 divided by 4/5
Equivalent Fractions of 3/9
What is the factorial of 6?
1/2 divided by what equals 3/4?
Reduce 5/25
What times 1/3 equals 1/2?
1/3 minus what equals 1/5?
4/9 Rounded to the Nearest Hundredth
What is 1/4 of 1/2?
3/4 Rounded to the Nearest Tenth
What is 4/5 as a decimal?
50/24 Rounded to the Nearest Whole Number
3/4 plus what equals 4/5?
Greatest Common Factor (GCF) of 2, 4 and 6
What is 3/2 as a Mixed Number?
Least Common Denominator (LCD) of 3, 9, and 20
What is 1 3/4 as a Decimal?
What plus 3/4 equals 2/5?
5 5/6 as a Percent
2 3/4 Rounded to the Nearest Half
What is 9 3/4 as an Improper Fraction?
3 3/4 Rounded to the Nearest Whole Number
How to calculate 5/6 times 3/2
What is the Quotient of 6/9?
What is the remainder of 4/5?
What is 48/52 simplified?
How to calculate 4/5 minus 3/4
How to Write 5/9 in Words
What minus 1/4 equals 1/3?
Copyright | Privacy Policy | Disclaimer | Contact
Location: http://www.mvps.org/dmcritchie/excel/fractex1.htm Home page: http://www.mvps.org/dmcritchie/excel/excel.htm[View without Frames]
The formatted display of fractional measurements in Excel leaves a lot to be desired. This example and the formulas shown below were generously provided by Bernie Deitrick as a follow-up to a posting 2000-08-04 in the microsoft.public.excel.misc newsgroup. Bernie's formulas will be simplified after comments from Harlan Grove and corrections from by Ron Rosenberg on 2003-01-03
The corrections to be made will allow the numbers to be treated arithmetically, though they are being formatted strictly for display. The other formulas showing mixed feet, inches and fractional inches will still requidre something more than these simplified formulas, and will be text to allow feet and inch marks to appear next to figures even if strictly Feet and fractional feet.
I believe the formula on this page will need some revision based on the following advice by Ron Rosenberg on 2003-01-26---------------- Examples for 1/4, 1/8, 1/16, 1/32, 1/64 -----------
for 4ths
=ROUND(A1*4,0)/4 -- format as 0 #/##
for 8ths
=ROUND(A1*8,0)/8 -- format as 0 #/##
for 16ths
=ROUND(A1*16,0)/16 -- format as 0 #/##
for 32nds
=ROUND(A1*32,0)/32 -- format as 0 #/##
for 64ths
=ROUND(A1*64,0)/64 -- format as 0 #/##
formula for cell E7:
=INT(A1/12)&' '&INT(MOD(A1,12))&'&IF(INT(A1)<>A1,' ' & TEXT(ROUND((A1-INT(A1/12)*12-INT(MOD(A1,12)))*128,0)/128,'##/###'),')&''
instead of his previous original beautiful formulas that is shown here to show some neat worksheet functions usage from his Aug 2000 examples: =INT(A1/12)&' ' & TEXT(MOD(A1,12),'0' &IF(ABS(MOD(A1,12)-ROUND(MOD(A1,12),0))>1/256, ' 0/'&CHOOSE(MATCH(MIN(ABS(ROUND(MOD(A1,12)*{2,4,8,16,32,64,128},0)-MOD(A1,12)*{2,4,8,16,32,64,128})/{2,4,8,16,32,64,128}),ABS(ROUND(MOD(A1,12)*{2,4,8,16,32,64,128},0)-MOD(A1,12)*{2,4,8,16,32,64,128})/{2,4,8,16,32,64,128},0),2,4,8,16,32,64,128),'))&''
| A | B | C | D | E | |
| 1 | 26.0827 | Fr: Simple Decimal To: Simple Fractions | Fr: Decimal Inches To: Fractional Inches | Fr: Decimal Feet To: Inches and Fractional Inches | Fr: Decimal Inches To: Feet, Inches and Fract. Inches |
| 2 | Down to 4ths | 26 | 26' | 26' 1' | 2' 2 0/4' |
| 3 | Down to 8ths | 26 1/8 | 26 1/8' | 26' 1' | 2' 2 1/8' |
| 4 | Down to 16ths | 26 1/16 | 26 1/16' | 26' 1' | 2' 2 1/16' |
| 5 | Down to 32nds | 26 3/32 | 26 3/32' | 26' 1' | 2' 2 3/32' |
| 6 | Down to 64ths | 26 5/64 | 26 5/64' | 26' 1' | 2' 2 5/64' |
| 7 | Down to 128ths | 26 11/128 | 26 11/128' | 26' 0 127/128' | 2' 2 11/128' |
| 8 | |||||
| 9 | This spreadsheet gives formulas used to display decimal values given in cell A1 as fractions with the denominator being variable and chosen as the smallest among 2,4,8,16.... as appropriate. Equations developed by Bernie Deitrick |
| b1 | Fr: Simple Decimal To: Simple Fractions | |
| b2 | 26 | =TEXT(A1,'0'&IF(ABS(A1-ROUND(A1,0))>1/8,' 0/'&CHOOSE(ROUND(MOD(A1,1)*4,0),4,2,4),')) =MROUND(A1,1/4) -- Analysis Toolpak Function -- format as 0 ##/## =ROUND(A1*4,0)/4 -- Without the Analysis Toolpak Function -- format as 0 ##/## |
| b3 | 26 1/8 | =TEXT(A1,'0'&IF(ABS(A1-ROUND(A1,0))>1/16,' 0/'&CHOOSE(ROUND(MOD(A1,1)*8,0),8,4,8,2,8,4,8),')) =MROUND(A1,1/8) -- Analysis Toolpak Function -- format as 0 ##/## |
| b4 | 26 1/16 | =TEXT(A1,'0'&IF(ABS(A1-ROUND(A1,0))>1/32,' 0/'&CHOOSE(ROUND(MOD(A1,1)*16,0),16,8,16,4,16,8,16,2,16,8,16,4,16,8,16),')) =MROUND(A1,1/16) -- Analysis Toolpak Function -- format as 0 ##/## |
| b5 | 26 3/32 | =TEXT(A1,'0' &IF(ABS(A1-ROUND(A1,0))>1/64, ' 0/'&CHOOSE(MATCH(MIN(ABS(ROUND(A1*{2,4,8,16,32},0)-A1*{2,4,8,16,32})/{2,4,8,16,32}),ABS(ROUND(A1*{2,4,8,16,32},0)-A1*{2,4,8,16,32})/{2,4,8,16,32},0),2,4,8,16,32),')) =MROUND(A1,1/32) -- Analysis Toolpak Function -- format as 0 ##/## |
| b6 | 26 5/64 | =TEXT(A1,'0' &IF(ABS(A1-ROUND(A1,0))>1/128, ' 0/'&CHOOSE(MATCH(MIN(ABS(ROUND(A1*{2,4,8,16,32,64},0)-A1*{2,4,8,16,32,64})/{2,4,8,16,32,64}),ABS(ROUND(A1*{2,4,8,16,32,64},0)-A1*{2,4,8,16,32,64})/{2,4,8,16,32,64},0),2,4,8,16,32,64),')) =MROUND(A1,1/64) -- Analysis Toolpak Function -- format as 0 ##/## |
| b7 | 26 11/128 | =TEXT(A1,'0' &IF(ABS(A1-ROUND(A1,0))>1/256, ' 0/'&CHOOSE(MATCH(MIN(ABS(ROUND(A1*{2,4,8,16,32,64,128},0)-A1*{2,4,8,16,32,64,128})/{2,4,8,16,32,64,128}),ABS(ROUND(A1*{2,4,8,16,32,64,128},0)-A1*{2,4,8,16,32,64,128})/{2,4,8,16,32,64,128},0),2,4,8,16,32,64,128),')) =MROUND(A1,1/128) -- Analysis Toolpak Function -- format as 0 ##/## |
| c1 | Fr: Decimal Inches To: Fractional Inches | |
| c2 | 26' | =TEXT(A1,'0'&IF(ABS(A1-ROUND(A1,0))>1/8,' 0/'&CHOOSE(ROUND(MOD(A1,1)*4,0),4,2,4),'))&'' |
| c3 | 26 1/8' | =TEXT(A1,'0'&IF(ABS(A1-ROUND(A1,0))>1/16,' 0/'&CHOOSE(ROUND(MOD(A1,1)*8,0),8,4,8,2,8,4,8),'))&'' |
| c4 | 26 1/16' | =TEXT(A1,'0'&IF(ABS(A1-ROUND(A1,0))>1/32,' 0/'&CHOOSE(ROUND(MOD(A1,1)*16,0),16,8,16,4,16,8,16,2,16,8,16,4,16,8,16),'))&'' |
| c5 | 26 3/32' | =TEXT(A1,'0' &IF(ABS(A1-ROUND(A1,0))>1/64, ' 0/'&CHOOSE(MATCH(MIN(ABS(ROUND(A1*{2,4,8,16,32},0)-A1*{2,4,8,16,32})/{2,4,8,16,32}),ABS(ROUND(A1*{2,4,8,16,32},0)-A1*{2,4,8,16,32})/{2,4,8,16,32},0),2,4,8,16,32),'))&'' |
| c6 | 26 5/64' | =TEXT(A1,'0' &IF(ABS(A1-ROUND(A1,0))>1/128, ' 0/'&CHOOSE(MATCH(MIN(ABS(ROUND(A1*{2,4,8,16,32,64},0)-A1*{2,4,8,16,32,64})/{2,4,8,16,32,64}),ABS(ROUND(A1*{2,4,8,16,32,64},0)-A1*{2,4,8,16,32,64})/{2,4,8,16,32,64},0),2,4,8,16,32,64),'))&'' |
| c7 | 26 11/128' | =TEXT(A1,'0' &IF(ABS(A1-ROUND(A1,0))>1/256, ' 0/'&CHOOSE(MATCH(MIN(ABS(ROUND(A1*{2,4,8,16,32,64,128},0)-A1*{2,4,8,16,32,64,128})/{2,4,8,16,32,64,128}),ABS(ROUND(A1*{2,4,8,16,32,64,128},0)-A1*{2,4,8,16,32,64,128})/{2,4,8,16,32,64,128},0),2,4,8,16,32,64,128),'))&'' |
| d1 | Fr: Decimal Feet To: Feet and Fractional Inches | |
| d2 | 26' 1' | =INT(A$1)&'&IF(INT(A$1)<>A$1,' ' & TEXT(ROUND((A$1-INT(A$1))*4,0)/4,'##/###'),')&'' |
| d3 | 26' 1' | =INT(A$1)&'&IF(INT(A$1)<>A$1,' ' & TEXT(ROUND((A$1-INT(A$1))*8,0)/8,'##/###'),')&'' |
| d4 | 26' 1' | =INT(A$1)&'&IF(INT(A$1)<>A$1,' ' & TEXT(ROUND((A$1-INT(A$1))*16,0)/16,'##/###'),')&'' |
| d5 | 26' 1' | =INT(A$1)&'&IF(INT(A$1)<>A$1,' ' & TEXT(ROUND((A$1-INT(A$1))*32,0)/32,'##/###'),')&'' |
| d6 | 26' 1' | =INT(A$1)&'&IF(INT(A$1)<>A$1,' ' & TEXT(ROUND((A$1-INT(A$1))*64,0)/64,'##/###'),')&'' |
| d7 | 26' 0 127/128' | =INT(A$1)&'&IF(INT(A$1)<>A$1,' ' & TEXT(ROUND((A$1-INT(A$1))*128,0)/128,'##/###'),')&'' |
| e1 | Fr: Decimal Inches To: Feet and Fractional Inches | |
| e2 | 2' 2 0/4' | =INT(A1/12)&' '&INT(MOD(A1,12))&'&IF(INT(A1)<>A1,' ' & TEXT(ROUND((A1-INT(A1/12)*12-INT(MOD(A1,12)))*4,0)/4,'##/##'),')&'' |
| e3 | 2' 2 1/8' | =INT(A1/12)&' '&INT(MOD(A1,12))&'&IF(INT(A1)<>A1,' ' & TEXT(ROUND((A1-INT(A1/12)*12-INT(MOD(A1,12)))*8,0)/8,'##/##'),')&'' |
| e4 | 2' 2 1/16' | =INT(A1/12)&' '&INT(MOD(A1,12))&'&IF(INT(A1)<>A1,' ' & TEXT(ROUND((A1-INT(A1/12)*12-INT(MOD(A1,12)))*16,0)/16,'##/##'),')&'' |
| e5 | 2' 2 3/32' | =INT(A1/12)&' '&INT(MOD(A1,12))&'&IF(INT(A1)<>A1,' ' & TEXT(ROUND((A1-INT(A1/12)*12-INT(MOD(A1,12)))*32,0)/32,'##/##'),')&'' |
| e6 | 2' 2 5/64' | =INT(A1/12)&' '&INT(MOD(A1,12))&'&IF(INT(A1)<>A1,' ' & TEXT(ROUND((A1-INT(A1/12)*12-INT(MOD(A1,12)))*64,0)/64,'##/##'),')&'' |
| e7 | 2' 2 11/128' | =INT(A1/12)&' '&INT(MOD(A1,12))&'&IF(INT(A1)<>A1,' ' & TEXT(ROUND((A1-INT(A1/12)*12-INT(MOD(A1,12)))*128,0)/128,'##/###'),')&'' |
Preparation of Data on this Page
A second sheet was copied from the original Excel spreadsheet supplied by Bernie and the formulas used were displayed as follows: A12: B2
B12: (pasted from B2)
C12: =GetFormula(indirect(A12))
The original section was converted to HTML with XL2HTMLX, and the formulas section was converted to HTML with XL2HTML with macros described on my HTML page.
Related
- This page is a continuation of the carpentry and fractions area on my Formula page.
- You can find some macros for conversions in an example spreadsheet. Look for 'feet-inch.xls' download at www.steel-link.com/2002/downloads/other.cfm This site is about tools and references for steel fabricating and detailing. Has AutoCad files, bolt calculation program, some fonts, things of interest to those working with steel.
- Conversion of Feet and Inches to Decimal Values, John Lacher, CPA
- allmath.com: Metric Conversion Tool, JAVA/HTML, more Martindale's Calculators On-Line Center (Over 18,135 calculators).
Visit [my Excel home page][Index page][Excel Onsite Search][top of this page]
Presentation in HTML format by David McRitchie
Appreciative comments should be directed to Bernie Deitrick mailto:deitbe@consumer.org for the content.
Photostitcher 2 1 2 Equals Grams
Please send your comments concerning formatting of this web page to: David McRitchie send email comments
Photostitcher 2 1 2 Equals 2/3
Copyright © 1997 - 2004, F. David McRitchie, All Rights Reserved // portions within tables © Bernie Deitrick
