SIMPLE RATIO

[Unlucky]

I did a search through the previous threads but wasn't able to find any that dealt specifically with a simple ratio.

I tried the =AD3/GCD(AD3,AD4) &”:”&AD4/GCD(AD3,AD4) but I end up with a #NAME? error. I search Google relentlessly, but there were no references to cell formatting (they are currently formatted as General. I'm not sure what I am missing.

TEST LOG FOR FORMULAS.xlsx
	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP
2	PE vs PR COMPARISON		JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	TOTAL
3	PROGRESS EVALUATION		24	34	36	25	16	24	18	14	28	30	28	36	313
4	PROCESS EVALUATION		12	17	9	20	16	8	9	10	7	10	7	9	134
5	RATION (PE to PR)		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
6	GCD		12	17	9	5	16	8	9	2	7	10	7	9
7
8	TOTAL FOR ALL YEARS (DATA FED BY OTHER CHARTS)	CORRECTIVE ACTION REQUESTS ISSUED DUE TO FINDINGS OBSERVED DURING PROGRESS EVALUATION (aka PE)
9		PROGRAM	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	TOTAL
10		A	1	0	1	4	2	3	1	0	1	1	2	3	19
11		B	2	2	1	2	1	4	0	1	1	1	2	8	25
12		C	0	5	1	2	1	0	0	1	1	0	3	1	15
13		D	4	4	1	2	0	1	1	2	2	2	4	2	25
14		E	1	3	4	2	0	1	1	1	1	3	1	2	20
15		F	0	3	5	4	1	2	0	0	1	4	5	4	29
16		G	0	1	5	1	2	0	2	3	0	4	1	3	22
17		H	3	4	2	1	2	2	2	2	2	3	1	1	25
18		I	2	1	3	0	2	2	2	2	3	5	1	1	24
19		J	1	1	2	2	0	1	5	1	4	4	1	1	23
20		K	3	5	1	2	0	0	2	0	2	0	1	2	18
21		L	5	2	3	0	1	2	2	1	1	1	2	0	20
22		M	0	2	6	0	0	4	0	0	0	0	3	4	19
23		N	2	1	1	3	4	2	0	0	9	2	1	4	29
24		TOTAL	24	34	36	25	16	24	18	14	28	30	28	36	313
25		PERCENTAGE	7.67%	10.86%	11.50%	7.99%	5.11%	7.67%	5.75%	4.47%	8.95%	9.58%	8.95%	11.50%
26
27	TOTAL FOR ALL YEARS (DATA FED BY OTHER CHARTS)	CORRECTIVE ACTION REQUESTS ISSUED DUE TO FINDINGS OBSERVED DURING PROCESS EVALUATION (aka PR)
28		PROGRAM	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	TOTAL
29		A	2	0	1	0	1	1	2	0	1	1	1	1	11
30		B	2	1	1	1	1	0	1	1	1	1	0	0	10
31		C	1	1	1	1	1	0	0	0	1	0	0	1	7
32		D	0	1	1	1	0	1	0	0	1	0	1	0	6
33		E	0	0	0	0	1	1	1	0	0	0	1	0	4
34		F	0	1	0	1	1	1	1	1	0	0	0	0	6
35		G	1	4	1	3	1	1	1	1	0	1	0	1	15
36		H	1	3	1	3	2	0	0	1	0	2	0	1	14
37		I	1	3	1	3	2	0	0	1	0	0	0	1	12
38		J	1	0	0	3	2	0	0	0	1	0	0	1	8
39		K	0	0	0	1	2	0	0	1	1	3	1	0	9
40		L	0	1	1	1	0	0	1	1	0	0	1	0	6
41		M	1	1	1	1	1	2	0	0	0	1	1	1	10
42		N	2	1	0	1	1	1	2	3	1	1	1	2	16
43		TOTAL	12	17	9	20	16	8	9	10	7	10	7	9	134
44		PERCENTAGE	8.96%	12.69%	6.72%	14.93%	11.94%	5.97%	6.72%	7.46%	5.22%	7.46%	5.22%	6.72%
FORMULA TEST

Cell Formulas
Range	Formula
AD3:AO3	AD3	=AD24
AP29:AP42,AP10:AP23,AP3:AP4	AP3	=SUM(AD3:AO3)
AD4:AO4	AD4	=AD43
AD5:AO5	AD5	=AD3/GCD(AD3,AD4) &”:”&AD4/GCD(AD3,AD4)
AD6:AO6	AD6	=GCD(AD3,AD4)
AC9,AC28	AC9	='[LOG_BAE_(06085)_OPEN-CARs_REVISED_DRAFT_2021-11-04.xlsx]DROP DOWNS'!$F$4
AD43:AP43,AD24:AP24	AD24	=SUM(AD10:AD23)
AD25:AO25	AD25	=IF(ISERROR(AD24/$AP$24),0,AD24/$AP$24)
AD44:AO44	AD44	=IF(ISERROR(AD43/$AP$43),0,AD43/$AP$43)

 

[Fluff]

You are using the wrong type of quotes, they should be " not slanted ”

 

[Unlucky]

Wow! I cut and pasted it from a Google search. Ugh!

Thanks again! You're awesome!

 

[Fluff]

You're welcome & thanks for the feedback.