One out of every X

[FredMcStaire]

I think this is a formatting question ( or could be something else and I'm just not seeing it). I'd like to display data as 1/x. So the numerator is always 1 and the denominator changes.
For example:

• 200/ 1000 = 1/5
• 2/5 = 1/10
• 330,000/330,000,000 = 1/1,000
• 403,000/330,000,000 = 1/819

Thank you
To clarify: I know the math to find the denominator, but not how to display it in the 1/x format.

 

[JLGWhiz]

Have you tried selecting the column where you want to display the results and formatting it as Fraction? Select the entire column, or just a range in the column, then right click to get the pop up menu. Click 'Format cells', then under Number, select "Fraction" and click OK.

 

[JGordon11]

Book1
	A	B	C	D	E
1	0.2	1/5.00000		0.2	1/5
2	0.4	1/2.50000		0.4	1/3
3	0.001	1/1000.00000		0.001	1/1000
4	0.001221	1/818.85856		0.001221	1/819
Sheet3

Cell Formulas
Range	Formula
A1,D1	A1	=200/1000
B1:B4	B1	="1/"&TEXT(1/A1,"0.00000")
A2,D2	A2	=2/5
A3,D3	A3	=330000/330000000
A4,D4	A4	=403000/330000000
E1:E4	E1	="1/" & ROUND(1/D1,0)

 

[FredMcStaire]

Have you tried selecting the column where you want to display the results and formatting it as Fraction? Select the entire column, or just a range in the column, then right click to get the pop up menu. Click 'Format cells', then under Number, select "Fraction" and click OK.

Thank you. That works for the format fractions up to 3 digits which is good for 1 out of 999, but not for more digits in the denominator . Which points out that I omitted a part of my question - making the solution versatile enough to go up to the one in a millions and hundreds of millions. Thanks again.

 

[FredMcStaire]

Book1
	A	B	C	D	E
1	0.2	1/5.00000		0.2	1/5
2	0.4	1/2.50000		0.4	1/3
3	0.001	1/1000.00000		0.001	1/1000
4	0.001221	1/818.85856		0.001221	1/819
Sheet3

Cell Formulas
Range	Formula
A1,D1	A1	=200/1000
B1:B4	B1	="1/"&TEXT(1/A1,"0.00000")
A2,D2	A2	=2/5
A3,D3	A3	=330000/330000000
A4,D4	A4	=403000/330000000
E1:E4	E1	="1/" & ROUND(1/D1,0)

Thank you.