Turn fraction around

[PabloFer]

Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1

 

[Rick Rothstein]

thats in K4 not whats in L4

I missed that when I posted my answer. To etaf's point... please show us the formula in L4 which is the value we think you want inverted.

 

[PabloFer]

The format in column L is in Fraction format 1/3, this is the one I need to take and turn around to show the denominator and numerator 3/1

 

[PabloFer]

I missed that when I posted my answer. To etaf's point... please show us the formula in L4 which is the value we think you want inverted.

The formula is a division =J4/F4 the result is 1/3 the format of cell L4 is in fraction and I need to present 3/1

 

[sandy666]

[

sndt1f701
	A	B	C	D	E	F	G	H	I	J	K	L
1	5/8	INTAKE NEEDED		INDOC		ACTUAL	REQ					Ratio
2
3	31-Aug	17	25	23	2	371	435	13
4	7-Sep	17	20	16	4	385	412	13	254	131	=J4/F4	1/3
5	14-Sep	18	15	12	3	394	412	13	254	143	36%	1/3
6	21-Sep	20		20	-20	434	412	13	255	163	38%	3/8
7	28-Sep	16		20	-20	474	412	13	256	183	39%	2/5
8	5-Oct	15		20	-20	514	493	13	257	203	39%	2/5
9	12-Oct	15		20	-20	554	493	13	258	223	40%	2/5
10	19-Oct	15		20	-20	594	493	13	259	243	41%	2/5
11	26-Oct	15		20	-20	634	493	13	260	263	41%	2/5
12	2-Nov	15		20	-20	674	560	15	261	283	42%	3/7
13	9-Nov	15		20	-20	714	560	15	262	303	42%	3/7
14	16-Nov	15		20	-20	754	560	15	263	323	43%	3/7
15	23-Nov	0		0	0	754	560	15	264	323	43%	3/7
16	30-Nov	0		0	0	754	560	15	265	323	43%	3/7
17	7-Dec	15		20	-20	794	624	16	266	343	43%	3/7
18	14-Dec			20	-20	834	624	16	267	363	44%	3/7
19	21-Dec			0	0	834	624	16	268	363	44%	3/7
Sheet1

column L is set to TEXT so maybe XL2BB cheating

 

[etaf]

if its text - then my formula should work

05-Aug​

INTAKE NEEDED

INDOC

ACTUAL

REQ

Ratio

31-Aug​

17​

25​

23​

2​

371​

435​

13​

07-Sep​

17​

20​

16​

4​

385​

412​

13​

254​

131​

#DIV/0!

1/3

3/1

14-Sep​

18​

15​

12​

3​

394​

412​

13​

254​

143​

0.36​

1/8

8/1

21-Sep​

20​

20​

-20​

434​

412​

13​

255​

163​

0.38​

1/13

13/1

28-Sep​

16​

20​

-20​

474​

412​

13​

256​

183​

0.39​

1/18

18/1

05-Oct​

15​

20​

-20​

514​

493​

13​

257​

203​

0.39​

1/23

23/1

12-Oct​

15​

20​

-20​

554​

493​

13​

258​

223​

0.4​

1/28

28/1

19-Oct​

15​

20​

-20​

594​

493​

13​

259​

243​

0.41​

1/33

33/1

26-Oct​

15​

20​

-20​

634​

493​

13​

260​

263​

0.41​

1/38

38/1

02-Nov​

15​

20​

-20​

674​

560​

15​

261​

283​

0.42​

1/43

43/1

09-Nov​

15​

20​

-20​

714​

560​

15​

262​

303​

0.42​

1/48

48/1

16-Nov​

15​

20​

-20​

754​

560​

15​

263​

323​

0.43​

1/53

53/1

23-Nov​

0​

0​

0​

754​

560​

15​

264​

323​

0.43​

1/58

58/1

30-Nov​

0​

0​

0​

754​

560​

15​

265​

323​

0.43​

1/63

63/1

07-Dec​

15​

20​

-20​

794​

624​

16​

266​

343​

0.43​

1/68

68/1

14-Dec​

20​

-20​

834​

624​

16​

267​

363​

0.44​

1/73

73/1

21-Dec​

0​

0​

834​

624​

16​

268​

363​

0.44​

1/78

78/1

 

[Rick Rothstein]

J4/F4 it works as it should the result is 1/3, but I need to present as 3/1, I need to change the denominator to the numerator

You did not look at the formula I posted carefully enough... I have the J4 and F4 reversed. I'll show you again...

=F4/J4

Try it to see (still set the cell format to Fraction).

 

[etaf]

perhaps a share as 1/3 is being converted to a number and then a date

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[PabloFer]

[

sndt1f701
	A	B	C	D	E	F	G	H	I	J	K	L
1	5/8	INTAKE NEEDED		INDOC		ACTUAL	REQ					Ratio
2
3	31-Aug	17	25	23	2	371	435	13
4	7-Sep	17	20	16	4	385	412	13	254	131	=J4/F4	1/3
5	14-Sep	18	15	12	3	394	412	13	254	143	36%	1/3
6	21-Sep	20		20	-20	434	412	13	255	163	38%	3/8
7	28-Sep	16		20	-20	474	412	13	256	183	39%	2/5
8	5-Oct	15		20	-20	514	493	13	257	203	39%	2/5
9	12-Oct	15		20	-20	554	493	13	258	223	40%	2/5
10	19-Oct	15		20	-20	594	493	13	259	243	41%	2/5
11	26-Oct	15		20	-20	634	493	13	260	263	41%	2/5
12	2-Nov	15		20	-20	674	560	15	261	283	42%	3/7
13	9-Nov	15		20	-20	714	560	15	262	303	42%	3/7
14	16-Nov	15		20	-20	754	560	15	263	323	43%	3/7
15	23-Nov	0		0	0	754	560	15	264	323	43%	3/7
16	30-Nov	0		0	0	754	560	15	265	323	43%	3/7
17	7-Dec	15		20	-20	794	624	16	266	343	43%	3/7
18	14-Dec			20	-20	834	624	16	267	363	44%	3/7
19	21-Dec			0	0	834	624	16	268	363	44%	3/7
Sheet1

column L is set to TEXT so maybe XL2BB cheating

View attachment 22508

That is correct is the result I have, but I need to present 3/1 instead the 1/3, I need to keep the formula because the file is reviewed for accuracy and need to keep track of what I am doing

 

[etaf]

i'll drop out now as Rick Rothstein has the answer
as I thought the format was TEXT as asked in first post and not formatted is a fraction

 

[sandy666]

That is correct is the result I have, but I need to present 3/1 instead the 1/3, I need to keep the formula because the file is reviewed for accuracy and need to keep track of what I am doing

I just "translated" from the picture to xl2bb, nothing more