Function parity: Excel vs. Zoho Sheet

The below table compares the list of functions available in Zoho Sheet against Excel.

S no	Excel Function	Zoho Sheet Function	Parity Status	Zoho Equivalent	Functional Parity	Gap Category	Legacy Name	Notes
1	ABS	ABS	Exact Match	ABS	Yes		No
2	ACCRINT	ACCRINT	Exact Match	ACCRINT	Yes		No
3	ACCRINTM	ACCRINTM	Exact Match	ACCRINTM	Yes		No
4	ACOS	ACOS	Exact Match	ACOS	Yes		No
5	ACOSH	ACOSH	Exact Match	ACOSH	Yes		No
6	ACOT	ACOT	Exact Match	ACOT	Yes		No
7	ACOTH	ACOTH	Exact Match	ACOTH	Yes		No
8	ADDRESS	ADDRESS	Exact Match	ADDRESS	Yes		No
9	AGGREGATE	AGGREGATE	Exact Match	AGGREGATE	Yes		No
10	AMORDEGRC	AMORDEGRC	Exact Match	AMORDEGRC	Yes		No
11	AMORLINC	AMORLINC	Exact Match	AMORLINC	Yes		No
12	AND	AND	Exact Match	AND	Yes		No
13	ARABIC	ARABIC	Exact Match	ARABIC	Yes		No
14	AREAS	AREAS	Exact Match	AREAS	Yes		No
15	ARRAYTOTEXT	ARRAYTOTEXT	Exact Match	ARRAYTOTEXT	Yes		No
16	ASC		Missing in Zoho		No	East-Asian/Byte Text	No
17	ASIN	ASIN	Exact Match	ASIN	Yes		No
18	ASINH	ASINH	Exact Match	ASINH	Yes		No
19	ATAN	ATAN	Exact Match	ATAN	Yes		No
20	ATAN2	ATAN2	Exact Match	ATAN2	Yes		No
21	ATANH	ATANH	Exact Match	ATANH	Yes		No
22	AVEDEV	AVEDEV	Exact Match	AVEDEV	Yes		No
23	AVERAGE	AVERAGE	Exact Match	AVERAGE	Yes		No
24	AVERAGEA	AVERAGEA	Exact Match	AVERAGEA	Yes		No
25	AVERAGEIF	AVERAGEIF	Exact Match	AVERAGEIF	Yes		No
26	AVERAGEIFS	AVERAGEIFS	Exact Match	AVERAGEIFS	Yes		No
27		B	Data Issue				No	Single-letter entry with no Excel counterpart - likely a truncated or stray row.
28	BAHTTEXT		Missing in Zoho		No	East-Asian/Byte Text	No
29	BASE	BASE	Exact Match	BASE	Yes		No
30	BESSELI	BESSELI	Exact Match	BESSELI	Yes		No
31	BESSELJ	BESSELJ	Exact Match	BESSELJ	Yes		No
32	BESSELK	BESSELK	Exact Match	BESSELK	Yes		No
33	BESSELY	BESSELY	Exact Match	BESSELY	Yes		No
34	BETA.DIST	BETADIST	Name Mismatch	BETADIST	Yes		No	Same function, different spelling (dotted vs. legacy name).
35	BETADIST (Legacy)		Alias Duplicate Row	BETADIST	Yes		Yes	Not a gap - Zoho has this as BETADIST, already recorded on Sno 34.
36	BETA.INV	BETAINV	Name Mismatch	BETAINV	Yes		No	Same function, different spelling (dotted vs. legacy name).
37	BETAINV (Legacy)		Alias Duplicate Row	BETAINV	Yes		Yes	Not a gap - Zoho has this as BETAINV, already recorded on Sno 36.
38	BIN2DEC	BIN2DEC	Exact Match	BIN2DEC	Yes		No
39	BIN2HEX	BIN2HEX	Exact Match	BIN2HEX	Yes		No
40	BIN2OCT	BIN2OCT	Exact Match	BIN2OCT	Yes		No
41	BINOM.DIST	BINOMDIST	Name Mismatch	BINOMDIST	Yes		No	Same function, different spelling (dotted vs. legacy name).
42	BINOM.DIST.RANGE		Missing in Zoho		No	Statistical Naming	No
43	BINOMDIST (Legacy)		Alias Duplicate Row	BINOMDIST	Yes		Yes	Not a gap - Zoho has this as BINOMDIST, already recorded on Sno 41.
44	BINOM.INV	BINOM.INV	Exact Match	BINOM.INV	Yes		No
45	BITAND	BITAND	Exact Match	BITAND	Yes		No
46	BITLSHIFT	BITLSHIFT	Exact Match	BITLSHIFT	Yes		No
47	BITOR	BITOR	Exact Match	BITOR	Yes		No
48	BITRSHIFT	BITRSHIFT	Exact Match	BITRSHIFT	Yes		No
49	BITXOR	BITXOR	Exact Match	BITXOR	Yes		No
50		BOTTOM	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
51	BYCOL	BYCOL	Exact Match	BYCOL	Yes		No
52	BYROW	BYROW	Exact Match	BYROW	Yes		No
53	CEILING (Legacy)		Alias Duplicate Row	CEILING	Yes		Yes	Not a gap - Zoho has this as CEILING, already recorded on Sno 55.
54	CEILING.MATH		Semantic Equivalent	CEILING	Partial	Rounding Variant	No	CEILING covers the basic case but has no mode argument for negative numbers.
55	CEILING.PRECISE	CEILING	Name Mismatch	CEILING	Partial	Statistical Naming	No	Mis-assignment: Zoho CEILING behaves like legacy CEILING, which is marked absent on Sno 53. CEILING.PRECISE always rounds toward +infinity regardless of sign.
56	CELL	CELL	Exact Match	CELL	Yes		No
57	CHAR	CHAR	Exact Match	CHAR	Yes		No
58	CHIDIST (Legacy)	CHIDIST	Name Mismatch	CHIDIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
59	CHIINV (Legacy)	CHIINV	Name Mismatch	CHIINV	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
60	CHISQ.DIST		Semantic Equivalent	CHIDIST	Partial	Statistical Naming	No	Only the right-tailed form exists in Zoho (CHIDIST / CHISQ.DIST.RT); the left-tailed and PDF forms are absent.
61	CHISQ.DIST.RT	CHISQ.DIST.RT	Exact Match	CHISQ.DIST.RT	Yes		No
62	CHISQ.INV		Semantic Equivalent	CHIINV	Partial	Statistical Naming	No	Only the right-tailed inverse exists in Zoho (CHIINV / CHISQ.INV.RT); the left-tailed form is absent.
63	CHISQ.INV.RT	CHISQ.INV.RT	Exact Match	CHISQ.INV.RT	Yes		No
64	CHISQ.TEST	CHITEST	Name Mismatch	CHITEST	Yes		No	Same function, different spelling (dotted vs. legacy name).
65	CHITEST (Legacy)		Alias Duplicate Row	CHITEST	Yes		Yes	Not a gap - Zoho has this as CHITEST, already recorded on Sno 64.
66	CHOOSE	CHOOSE	Exact Match	CHOOSE	Yes		No
67	CHOOSECOLS	CHOOSECOLS	Exact Match	CHOOSECOLS	Yes		No
68	CHOOSEROWS	CHOOSEROWS	Exact Match	CHOOSEROWS	Yes		No
69	CLEAN	CLEAN	Exact Match	CLEAN	Yes		No
70	CODE	CODE	Exact Match	CODE	Yes		No
71	COLUMN	COLUMN	Exact Match	COLUMN	Yes		No
72	COLUMNS	COLUMNS	Exact Match	COLUMNS	Yes		No
73	COMBIN	COMBIN	Exact Match	COMBIN	Yes		No
74	COMBINA	COMBINA	Exact Match	COMBINA	Yes		No
75	COMPLEX	COMPLEX	Exact Match	COMPLEX	Yes		No
76	CONCAT	CONCATENATE	Name Mismatch	CONCATENATE	Partial	Misc	No	Mis-assignment: Excel CONCAT accepts ranges, CONCATENATE does not. Zoho CONCATENATE is the match for the CONCATENATE (Legacy) row (Sno 77), which is marked absent.
77	CONCATENATE (Legacy)		Alias Duplicate Row	CONCATENATE	Yes		Yes	Not a gap - Zoho has this as CONCATENATE, already recorded on Sno 76.
78	CONFIDENCE (Legacy)	CONFIDENCE	Name Mismatch	CONFIDENCE	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
79	CONFIDENCE.NORM	CONFIDENCE.NORM	Exact Match	CONFIDENCE.NORM	Yes		No
80	CONFIDENCE.T	CONFIDENCE.T	Exact Match	CONFIDENCE.T	Yes		No
81	CONVERT	CONVERT	Exact Match	CONVERT	Yes		No
82	CORREL	CORREL	Exact Match	CORREL	Yes		No
83	COS	COS	Exact Match	COS	Yes		No
84	COSH	COSH	Exact Match	COSH	Yes		No
85	COT	COT	Exact Match	COT	Yes		No
86	COTH	COTH	Exact Match	COTH	Yes		No
87	COUNT	COUNT	Exact Match	COUNT	Yes		No
88	COUNTA	COUNTA	Exact Match	COUNTA	Yes		No
89	COUNTBLANK	COUNTBLANK	Exact Match	COUNTBLANK	Yes		No
90	COUNTIF	COUNTIF	Exact Match	COUNTIF	Yes		No
91	COUNTIFS	COUNTIFS	Exact Match	COUNTIFS	Yes		No
92	COUPDAYBS	COUPDAYBS	Exact Match	COUPDAYBS	Yes		No
93	COUPDAYS	COUPDAYS	Exact Match	COUPDAYS	Yes		No
94	COUPDAYSNC	COUPDAYSNC	Exact Match	COUPDAYSNC	Yes		No
95	COUPNCD	COUPNCD	Exact Match	COUPNCD	Yes		No
96	COUPNUM	COUPNUM	Exact Match	COUPNUM	Yes		No
97	COUPPCD	COUPPCD	Exact Match	COUPPCD	Yes		No
98	COVAR (Legacy)	COVAR	Name Mismatch	COVAR	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
99	COVARIANCE.P		Semantic Equivalent	COVAR	Yes		No	Identical function under legacy name.
100	COVARIANCE.S	COVARIANCE.S	Exact Match	COVARIANCE.S	Yes		No
101	CRITBINOM (Legacy)	CRITBINOM	Name Mismatch	CRITBINOM	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
102	CSC	CSC	Exact Match	CSC	Yes		No
103	CSCH	CSCH	Exact Match	CSCH	Yes		No
104	CUBEKPIMEMBER		Missing in Zoho		No	Cube/OLAP	No
105	CUBEMEMBER		Missing in Zoho		No	Cube/OLAP	No
106	CUBEMEMBERPROPERTY		Missing in Zoho		No	Cube/OLAP	No
107	CUBERANKEDMEMBER		Missing in Zoho		No	Cube/OLAP	No
108	CUBESET		Missing in Zoho		No	Cube/OLAP	No
109	CUBESETCOUNT		Missing in Zoho		No	Cube/OLAP	No
110	CUBEVALUE		Missing in Zoho		No	Cube/OLAP	No
111	CUMIPMT	CUMIPMT	Exact Match	CUMIPMT	Yes		No
112	CUMPRINC	CUMPRINC	Exact Match	CUMPRINC	Yes		No
113		CURRENCY	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
114		CURRENT	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
115	DATE	DATE	Exact Match	DATE	Yes		No
116	DATEDIF	DATEDIF	Exact Match	DATEDIF	Yes		No
117	DATEVALUE	DATEVALUE	Exact Match	DATEVALUE	Yes		No
118	DAVERAGE	DAVERAGE	Exact Match	DAVERAGE	Yes		No
119	DAY	DAY	Exact Match	DAY	Yes		No
120	DAYS	DAYS	Exact Match	DAYS	Yes		No
121	DAYS360	DAYS360	Exact Match	DAYS360	Yes		No
122		DAYSINMONTH	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
123		DAYSINYEAR	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
124	DB	DB	Exact Match	DB	Yes		No
125	DBCS		Missing in Zoho		No	East-Asian/Byte Text	No
126	DCOUNT	DCOUNT	Exact Match	DCOUNT	Yes		No
127	DCOUNTA	DCOUNTA	Exact Match	DCOUNTA	Yes		No
128	DDB	DDB	Exact Match	DDB	Yes		No
129	DEC2BIN	DEC2BIN	Exact Match	DEC2BIN	Yes		No
130	DEC2HEX	DEC2HEX	Exact Match	DEC2HEX	Yes		No
131	DEC2OCT	DEC2OCT	Exact Match	DEC2OCT	Yes		No
132	DECIMAL	DECIMAL	Exact Match	DECIMAL	Yes		No
133	DEGREES	DEGREES	Exact Match	DEGREES	Yes		No
134	DELTA	DELTA	Exact Match	DELTA	Yes		No
135	DETECTLANGUAGE		Missing in Zoho		No	Modern Excel (2023+)	No
136	DEVSQ	DEVSQ	Exact Match	DEVSQ	Yes		No
137	DGET	DGET	Exact Match	DGET	Yes		No
138	DISC	DISC	Exact Match	DISC	Yes		No
139	DMAX	DMAX	Exact Match	DMAX	Yes		No
140	DMIN	DMIN	Exact Match	DMIN	Yes		No
141	DOLLAR	DOLLAR	Exact Match	DOLLAR	Yes		No
142	DOLLARDE	DOLLARDE	Exact Match	DOLLARDE	Yes		No
143	DOLLARFR	DOLLARFR	Exact Match	DOLLARFR	Yes		No
144	DPRODUCT	DPRODUCT	Exact Match	DPRODUCT	Yes		No
145	DROP	DROP	Exact Match	DROP	Yes		No
146	DSTDEV	DSTDEV	Exact Match	DSTDEV	Yes		No
147	DSTDEVP	DSTDEVP	Exact Match	DSTDEVP	Yes		No
148	DSUM	DSUM	Exact Match	DSUM	Yes		No
149	DURATION	DURATION	Exact Match	DURATION	Yes		No
150	DVAR	DVAR	Exact Match	DVAR	Yes		No
151	DVARP	DVARP	Exact Match	DVARP	Yes		No
152		EASTERSUNDAY	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
153	EDATE	EDATE	Exact Match	EDATE	Yes		No
154	EFFECT	EFFECT	Exact Match	EFFECT	Yes		No
155	ENCODEURL	ENCODEURL	Exact Match	ENCODEURL	Yes		No
156	EOMONTH	EOMONTH	Exact Match	EOMONTH	Yes		No
157	ERF	ERF	Exact Match	ERF	Yes		No
158	ERF.PRECISE		Semantic Equivalent	ERF	Partial	Statistical Naming	No	ERF covers it; ERF.PRECISE takes only the lower limit.
159	ERFC	ERFC	Exact Match	ERFC	Yes		No
160	ERFC.PRECISE		Semantic Equivalent	ERFC	Yes		No	Identical function under legacy name.
161	ERROR.TYPE	ERRORTYPE	Name Mismatch	ERRORTYPE	Yes		No	Same function, different spelling (dotted vs. legacy name).
162	EVEN	EVEN	Exact Match	EVEN	Yes		No
163	EXACT	EXACT	Exact Match	EXACT	Yes		No
164	EXP	EXP	Exact Match	EXP	Yes		No
165	EXPAND	EXPAND	Exact Match	EXPAND	Yes		No
166	EXPON.DIST	EXPONDIST	Name Mismatch	EXPONDIST	Yes		No	Same function, different spelling (dotted vs. legacy name).
167	EXPONDIST (Legacy)		Alias Duplicate Row	EXPONDIST	Yes		Yes	Not a gap - Zoho has this as EXPONDIST, already recorded on Sno 166.
168	F.DIST		Alias Duplicate Row	FDIST	Yes		No	Not a gap - Zoho has this as FDIST, already recorded on Sno 176.
169	F.DIST.RT	F.DIST.RT	Exact Match	F.DIST.RT	Yes		No
170	F.INV		Alias Duplicate Row	FINV	Yes		No	Not a gap - Zoho has this as FINV, already recorded on Sno 181.
171	F.INV.RT	F.INV.RT	Exact Match	F.INV.RT	Yes		No
172	F.TEST		Alias Duplicate Row	FTEST	Yes		No	Not a gap - Zoho has this as FTEST, already recorded on Sno 197.
173	FACT	FACT	Exact Match	FACT	Yes		No
174	FACTDOUBLE	FACTDOUBLE	Exact Match	FACTDOUBLE	Yes		No
175	FALSE	FALSE	Exact Match	FALSE	Yes		No
176	FDIST (Legacy)	FDIST	Name Mismatch	FDIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
177	FILTER	FILTER	Exact Match	FILTER	Yes		No
178	FILTERXML		Missing in Zoho		No	External/Web Data	No
179	FIND	FIND	Exact Match	FIND	Yes		No
180	FINDB		Missing in Zoho		No	East-Asian/Byte Text	No
181	FINV (Legacy)	FINV	Name Mismatch	FINV	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
182	FISHER	FISHER	Exact Match	FISHER	Yes		No
183	FISHERINV	FISHERINV	Exact Match	FISHERINV	Yes		No
184	FIXED	FIXED	Exact Match	FIXED	Yes		No
185	FLOOR (Legacy)	FLOOR	Name Mismatch	FLOOR	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
186	FLOOR.MATH		Semantic Equivalent	FLOOR	Partial	Rounding Variant	No	FLOOR covers the basic case but has no mode argument for negative numbers.
187	FLOOR.PRECISE		Semantic Equivalent	FLOOR	Partial	Rounding Variant	No	FLOOR covers the basic case; negative-number rounding direction differs.
188	FORECAST (Legacy)	FORECAST	Name Mismatch	FORECAST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
189	FORECAST.ETS		Missing in Zoho		No	Forecast ETS	No
190	FORECAST.ETS.CONFINT		Missing in Zoho		No	Forecast ETS	No
191	FORECAST.ETS.SEASONALITY		Missing in Zoho		No	Forecast ETS	No
192	FORECAST.ETS.STAT		Missing in Zoho		No	Forecast ETS	No
193	FORECAST.LINEAR		Semantic Equivalent	FORECAST	Yes		No	FORECAST.LINEAR is a straight rename of FORECAST.
194		FORMULA	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
195	FORMULATEXT	FORMULATEXT	Exact Match	FORMULATEXT	Yes		No
196	FREQUENCY	FREQUENCY	Exact Match	FREQUENCY	Yes		No
197	FTEST (Legacy)	FTEST	Name Mismatch	FTEST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
198	FV	FV	Exact Match	FV	Yes		No
199	FVSCHEDULE	FVSCHEDULE	Exact Match	FVSCHEDULE	Yes		No
200	GAMMA	GAMMA	Exact Match	GAMMA	Yes		No
201	GAMMA.DIST		Alias Duplicate Row	GAMMADIST	Yes		No	Not a gap - Zoho has this as GAMMADIST, already recorded on Sno 203.
202	GAMMA.INV		Alias Duplicate Row	GAMMAINV	Yes		No	Not a gap - Zoho has this as GAMMAINV, already recorded on Sno 204.
203	GAMMADIST (Legacy)	GAMMADIST	Name Mismatch	GAMMADIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
204	GAMMAINV (Legacy)	GAMMAINV	Name Mismatch	GAMMAINV	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
205	GAMMALN	GAMMALN	Exact Match	GAMMALN	Yes		No
206	GAMMALN.PRECISE		Semantic Equivalent	GAMMALN	Yes		No	Identical function under legacy name.
207	GAUSS	GAUSS	Exact Match	GAUSS	Yes		No
208	GCD	GCD	Exact Match	GCD	Yes		No
209	GEOMEAN	GEOMEAN	Exact Match	GEOMEAN	Yes		No
210	GESTEP	GESTEP	Exact Match	GESTEP	Yes		No
211	GETPIVOTDATA	GETPIVOTDATA	Exact Match	GETPIVOTDATA	Yes		No
212	GROUPBY		Missing in Zoho		No	Modern Excel (2023+)	No
213	GROWTH	GROWTH	Exact Match	GROWTH	Yes		No
214	HARMEAN	HARMEAN	Exact Match	HARMEAN	Yes		No
215	HEX2BIN	HEX2BIN	Exact Match	HEX2BIN	Yes		No
216	HEX2DEC	HEX2DEC	Exact Match	HEX2DEC	Yes		No
217	HEX2OCT	HEX2OCT	Exact Match	HEX2OCT	Yes		No
218	HLOOKUP	HLOOKUP	Exact Match	HLOOKUP	Yes		No
219	HOUR	HOUR	Exact Match	HOUR	Yes		No
220	HSTACK	HSTACK	Exact Match	HSTACK	Yes		No
221	HYPERLINK	HYPERLINK	Exact Match	HYPERLINK	Yes		No
222	HYPGEOM.DIST		Alias Duplicate Row	HYPGEOMDIST	Yes		No	Not a gap - Zoho has this as HYPGEOMDIST, already recorded on Sno 223.
223	HYPGEOMDIST (Legacy)	HYPGEOMDIST	Name Mismatch	HYPGEOMDIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
224	IF	IF	Exact Match	IF	Yes		No
225	IFERROR	IFERROR	Exact Match	IFERROR	Yes		No
226	IFNA	IFNA	Exact Match	IFNA	Yes		No
227	IFS	IFS	Exact Match	IFS	Yes		No
228	IMABS	IMABS	Exact Match	IMABS	Yes		No
229	IMAGE	IMAGE	Exact Match	IMAGE	Yes		No
230	IMAGINARY	IMAGINARY	Exact Match	IMAGINARY	Yes		No
231	IMARGUMENT	IMARGUMENT	Exact Match	IMARGUMENT	Yes		No
232	IMCONJUGATE	IMCONJUGATE	Exact Match	IMCONJUGATE	Yes		No
233	IMCOS	IMCOS	Exact Match	IMCOS	Yes		No
234	IMCOSH	IMCOSH	Exact Match	IMCOSH	Yes		No
235	IMCOT	IMCOT	Exact Match	IMCOT	Yes		No
236	IMCSC	IMCSC	Exact Match	IMCSC	Yes		No
237	IMCSCH	IMCSCH	Exact Match	IMCSCH	Yes		No
238	IMDIV	IMDIV	Exact Match	IMDIV	Yes		No
239	IMEXP	IMEXP	Exact Match	IMEXP	Yes		No
240	IMLN	IMLN	Exact Match	IMLN	Yes		No
241	IMLOG10	IMLOG10	Exact Match	IMLOG10	Yes		No
242	IMLOG2	IMLOG2	Exact Match	IMLOG2	Yes		No
243		IMPORTRANGE	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
244	IMPOWER	IMPOWER	Exact Match	IMPOWER	Yes		No
245	IMPRODUCT	IMPRODUCT	Exact Match	IMPRODUCT	Yes		No
246	IMREAL	IMREAL	Exact Match	IMREAL	Yes		No
247	IMSEC	IMSEC	Exact Match	IMSEC	Yes		No
248	IMSECH	IMSECH	Exact Match	IMSECH	Yes		No
249	IMSIN	IMSIN	Exact Match	IMSIN	Yes		No
250	IMSINH	IMSINH	Exact Match	IMSINH	Yes		No
251	IMSQRT	IMSQRT	Exact Match	IMSQRT	Yes		No
252	IMSUB	IMSUB	Exact Match	IMSUB	Yes		No
253	IMSUM	IMSUM	Exact Match	IMSUM	Yes		No
254	IMTAN	IMTAN	Exact Match	IMTAN	Yes		No
255	INDEX	INDEX	Exact Match	INDEX	Yes		No
256	INDIRECT	INDIRECT	Exact Match	INDIRECT	Yes		No
257	INFO		Missing in Zoho		No	Misc	No
258	INT	INT	Exact Match	INT	Yes		No
259	INTERCEPT	INTERCEPT	Exact Match	INTERCEPT	Yes		No
260	INTRATE	INTRATE	Exact Match	INTRATE	Yes		No
261	IPMT	IPMT	Exact Match	IPMT	Yes		No
262	IRR	IRR	Exact Match	IRR	Yes		No
263	ISBLANK	ISBLANK	Exact Match	ISBLANK	Yes		No
264	ISERR	ISERR	Exact Match	ISERR	Yes		No
265	ISERROR	ISERROR	Exact Match	ISERROR	Yes		No
266	ISEVEN	ISEVEN	Exact Match	ISEVEN	Yes		No
267	ISFORMULA	ISFORMULA	Exact Match	ISFORMULA	Yes		No
268		ISLEAPYEAR	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
269	ISLOGICAL	ISLOGICAL	Exact Match	ISLOGICAL	Yes		No
270	ISNA	ISNA	Exact Match	ISNA	Yes		No
271	ISNONTEXT	ISNONTEXT	Exact Match	ISNONTEXT	Yes		No
272	ISNUMBER	ISNUMBER	Exact Match	ISNUMBER	Yes		No
273	ISO.CEILING		Semantic Equivalent	CEILING	Partial	Rounding Variant	No	CEILING covers the basic case; negative-number rounding direction differs.
274	ISODD	ISODD	Exact Match	ISODD	Yes		No
275	ISOMITTED		Missing in Zoho		No	Modern Excel (2023+)	No
276	ISOWEEKNUM		Missing in Zoho		No	Misc	No
277	ISPMT	ISPMT	Exact Match	ISPMT	Yes		No
278	ISREF	ISREF	Exact Match	ISREF	Yes		No
279	ISTEXT	ISTEXT	Exact Match	ISTEXT	Yes		No
280	JIS		Missing in Zoho		No	East-Asian/Byte Text	No
281	KURT	KURT	Exact Match	KURT	Yes		No
282	LAMBDA	LAMBDA	Exact Match	LAMBDA	Yes		No
283	LARGE	LARGE	Exact Match	LARGE	Yes		No
284	LCM	LCM	Exact Match	LCM	Yes		No
285	LEFT	LEFT	Exact Match	LEFT	Yes		No
286	LEFTB		Missing in Zoho		No	East-Asian/Byte Text	No
287	LEN	LEN	Exact Match	LEN	Yes		No
288	LENB		Missing in Zoho		No	East-Asian/Byte Text	No
289	LET	LET	Exact Match	LET	Yes		No
290	LINEST	LINEST	Exact Match	LINEST	Yes		No
291	LN	LN	Exact Match	LN	Yes		No
292	LOG	LOG	Exact Match	LOG	Yes		No
293	LOG10	LOG10	Exact Match	LOG10	Yes		No
294	LOGEST	LOGEST	Exact Match	LOGEST	Yes		No
295	LOGINV (Legacy)	LOGINV	Name Mismatch	LOGINV	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
296	LOGNORM.DIST		Alias Duplicate Row	LOGNORMDIST	Yes		No	Not a gap - Zoho has this as LOGNORMDIST, already recorded on Sno 298.
297	LOGNORM.INV	LOGNORM.INV	Exact Match	LOGNORM.INV	Yes		No
298	LOGNORMDIST (Legacy)	LOGNORMDIST	Name Mismatch	LOGNORMDIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
299	LOOKUP	LOOKUP	Exact Match	LOOKUP	Yes		No
300	LOWER	LOWER	Exact Match	LOWER	Yes		No
301	MAKEARRAY	MAKEARRAY	Exact Match	MAKEARRAY	Yes		No
302	MAP	MAP	Exact Match	MAP	Yes		No
303	MATCH	MATCH	Exact Match	MATCH	Yes		No
304	MAX	MAX	Exact Match	MAX	Yes		No
305	MAXA	MAXA	Exact Match	MAXA	Yes		No
306	MAXIFS	MAXIFS	Exact Match	MAXIFS	Yes		No
307	MDETERM	MDETERM	Exact Match	MDETERM	Yes		No
308	MDURATION	MDURATION	Exact Match	MDURATION	Yes		No
309	MEDIAN	MEDIAN	Exact Match	MEDIAN	Yes		No
310	MID	MID	Exact Match	MID	Yes		No
311	MIDB		Missing in Zoho		No	East-Asian/Byte Text	No
312	MIN	MIN	Exact Match	MIN	Yes		No
313	MINA	MINA	Exact Match	MINA	Yes		No
314	MINIFS	MINIFS	Exact Match	MINIFS	Yes		No
315	MINUTE	MINUTE	Exact Match	MINUTE	Yes		No
316	MINVERSE	MINVERSE	Exact Match	MINVERSE	Yes		No
317	MIRR	MIRR	Exact Match	MIRR	Yes		No
318	MMULT	MMULT	Exact Match	MMULT	Yes		No
319	MOD	MOD	Exact Match	MOD	Yes		No
320	MODE (Legacy)	MODE	Name Mismatch	MODE	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
321	MODE.MULT	MODE.MULT	Exact Match	MODE.MULT	Yes		No
322	MODE.SNGL		Semantic Equivalent	MODE	Yes		No	Identical function under legacy name.
323	MONTH	MONTH	Exact Match	MONTH	Yes		No
324		MONTHS	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
325	MROUND	MROUND	Exact Match	MROUND	Yes		No
326	MULTINOMIAL	MULTINOMIAL	Exact Match	MULTINOMIAL	Yes		No
327	MUNIT	MUNIT	Exact Match	MUNIT	Yes		No
328	N	N	Exact Match	N	Yes		No
329	NA	NA	Exact Match	NA	Yes		No
330	NEGBINOM.DIST		Alias Duplicate Row	NEGBINOMDIST	Yes		No	Not a gap - Zoho has this as NEGBINOMDIST, already recorded on Sno 331.
331	NEGBINOMDIST (Legacy)	NEGBINOMDIST	Name Mismatch	NEGBINOMDIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
332	NETWORKDAYS	NETWORKDAYS	Exact Match	NETWORKDAYS	Yes		No
333	NETWORKDAYS.INTL	NETWORKDAYS.INTL	Exact Match	NETWORKDAYS.INTL	Yes		No
334	NOMINAL	NOMINAL	Exact Match	NOMINAL	Yes		No
335	NORM.DIST		Alias Duplicate Row	NORMDIST	Yes		No	Not a gap - Zoho has this as NORMDIST, already recorded on Sno 339.
336	NORM.INV		Alias Duplicate Row	NORMINV	Yes		No	Not a gap - Zoho has this as NORMINV, already recorded on Sno 340.
337	NORM.S.DIST		Alias Duplicate Row	NORMSDIST	Yes		No	Not a gap - Zoho has this as NORMSDIST, already recorded on Sno 341.
338	NORM.S.INV		Alias Duplicate Row	NORMSINV	Yes		No	Not a gap - Zoho has this as NORMSINV, already recorded on Sno 342.
339	NORMDIST (Legacy)	NORMDIST	Name Mismatch	NORMDIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
340	NORMINV (Legacy)	NORMINV	Name Mismatch	NORMINV	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
341	NORMSDIST (Legacy)	NORMSDIST	Name Mismatch	NORMSDIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
342	NORMSINV (Legacy)	NORMSINV	Name Mismatch	NORMSINV	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
343	NOT	NOT	Exact Match	NOT	Yes		No
344	NOW	NOW	Exact Match	NOW	Yes		No
345	NPER	NPER	Exact Match	NPER	Yes		No
346	NPV	NPV	Exact Match	NPV	Yes		No
347	NUMBERSTRING		Missing in Zoho		No	East-Asian/Byte Text	No
348	NUMBERVALUE	NUMBERVALUE	Exact Match	NUMBERVALUE	Yes		No
349	OCT2BIN	OCT2BIN	Exact Match	OCT2BIN	Yes		No
350	OCT2DEC	OCT2DEC	Exact Match	OCT2DEC	Yes		No
351	OCT2HEX	OCT2HEX	Exact Match	OCT2HEX	Yes		No
352	ODD	ODD	Exact Match	ODD	Yes		No
353	ODDFPRICE	ODDFPRICE	Exact Match	ODDFPRICE	Yes		No
354	ODDFYIELD	ODDFYIELD	Exact Match	ODDFYIELD	Yes		No
355	ODDLPRICE	ODDLPRICE	Exact Match	ODDLPRICE	Yes		No
356	ODDLYIELD	ODDLYIELD	Exact Match	ODDLYIELD	Yes		No
357	OFFSET	OFFSET	Exact Match	OFFSET	Yes		No
358	OR	OR	Exact Match	OR	Yes		No
359	PDURATION	PDURATION	Exact Match	PDURATION	Yes		No
360	PEARSON	PEARSON	Exact Match	PEARSON	Yes		No
361	PERCENTILE (Legacy)	PERCENTILE	Name Mismatch	PERCENTILE	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
362	PERCENTILE.EXC	PERCENTILE.EXC	Exact Match	PERCENTILE.EXC	Yes		No
363	PERCENTILE.INC	PERCENTILE.INC	Exact Match	PERCENTILE.INC	Yes		No
364	PERCENTOF		Missing in Zoho		No	Modern Excel (2023+)	No
365	PERCENTRANK (Legacy)	PERCENTRANK	Name Mismatch	PERCENTRANK	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
366	PERCENTRANK.EXC	PERCENTRANK.EXC	Exact Match	PERCENTRANK.EXC	Yes		No
367	PERCENTRANK.INC	PERCENTRANK.INC	Exact Match	PERCENTRANK.INC	Yes		No
368	PERMUT	PERMUT	Exact Match	PERMUT	Yes		No
369	PERMUTATIONA	PERMUTATIONA	Exact Match	PERMUTATIONA	Yes		No
370	PHI	PHI	Exact Match	PHI	Yes		No
371	PHONETIC		Missing in Zoho		No	East-Asian/Byte Text	No
372	PI	PI	Exact Match	PI	Yes		No
373	PIVOTBY		Missing in Zoho		No	Modern Excel (2023+)	No
374	PMT	PMT	Exact Match	PMT	Yes		No
375	POISSON (Legacy)	POISSON	Name Mismatch	POISSON	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
376	POISSON.DIST		Semantic Equivalent	POISSON	Yes		No	Identical function under legacy name.
377	POWER	POWER	Exact Match	POWER	Yes		No
378	PPMT	PPMT	Exact Match	PPMT	Yes		No
379	PRICE	PRICE	Exact Match	PRICE	Yes		No
380	PRICEDISC	PRICEDISC	Exact Match	PRICEDISC	Yes		No
381	PRICEMAT	PRICEMAT	Exact Match	PRICEMAT	Yes		No
382	PROB	PROB	Exact Match	PROB	Yes		No
383	PRODUCT	PRODUCT	Exact Match	PRODUCT	Yes		No
384	PROPER	PROPER	Exact Match	PROPER	Yes		No
385	PV	PV	Exact Match	PV	Yes		No
386	PY		Missing in Zoho		No	Modern Excel (2023+)	No
387	QUARTILE (Legacy)	QUARTILE	Name Mismatch	QUARTILE	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
388	QUARTILE.EXC	QUARTILE.EXC	Exact Match	QUARTILE.EXC	Yes		No
389	QUARTILE.INC	QUARTILE.INC	Exact Match	QUARTILE.INC	Yes		No
390	QUOTIENT	QUOTIENT	Exact Match	QUOTIENT	Yes		No
391	RADIANS	RADIANS	Exact Match	RADIANS	Yes		No
392	RAND	RAND	Exact Match	RAND	Yes		No
393	RANDARRAY	RANDARRAY	Exact Match	RANDARRAY	Yes		No
394	RANDBETWEEN	RANDBETWEEN	Exact Match	RANDBETWEEN	Yes		No
395	RANK (Legacy)	RANK	Name Mismatch	RANK	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
396	RANK.AVG	RANK.AVG	Exact Match	RANK.AVG	Yes		No
397	RANK.EQ	RANK.EQ	Exact Match	RANK.EQ	Yes		No
398	RATE	RATE	Exact Match	RATE	Yes		No
399	RECEIVED	RECEIVED	Exact Match	RECEIVED	Yes		No
400	REDUCE	REDUCE	Exact Match	REDUCE	Yes		No
401	REGEXEXTRACT		Missing in Zoho		No	Modern Excel (2023+)	No
402	REGEXREPLACE		Missing in Zoho		No	Modern Excel (2023+)	No
403	REGEXTEST		Missing in Zoho		No	Modern Excel (2023+)	No
404	REPLACE	REPLACE	Exact Match	REPLACE	Yes		No
405	REPLACEB		Missing in Zoho		No	East-Asian/Byte Text	No
406	REPT	REPT	Exact Match	REPT	Yes		No
407	RIGHT	RIGHT	Exact Match	RIGHT	Yes		No
408	RIGHTB		Missing in Zoho		No	East-Asian/Byte Text	No
409	ROMAN	ROMAN	Exact Match	ROMAN	Yes		No
410	ROUND	ROUND	Exact Match	ROUND	Yes		No
411	ROUNDDOWN	ROUNDDOWN	Exact Match	ROUNDDOWN	Yes		No
412	ROUNDUP	ROUNDUP	Exact Match	ROUNDUP	Yes		No
413	ROW	ROW	Exact Match	ROW	Yes		No
414	ROWS	ROWS	Exact Match	ROWS	Yes		No
415	RRI	RRI	Exact Match	RRI	Yes		No
416	RSQ	RSQ	Exact Match	RSQ	Yes		No
417	RTD		Missing in Zoho		No	External/Web Data	No
418	SCAN	SCAN	Exact Match	SCAN	Yes		No
419	SEARCH	SEARCH	Exact Match	SEARCH	Yes		No
420	SEARCHB		Missing in Zoho		No	East-Asian/Byte Text	No
421	SEC	SEC	Exact Match	SEC	Yes		No
422	SECH	SECH	Exact Match	SECH	Yes		No
423	SECOND	SECOND	Exact Match	SECOND	Yes		No
424	SEQUENCE	SEQUENCE	Exact Match	SEQUENCE	Yes		No
425	SERIESSUM	SERIESSUM	Exact Match	SERIESSUM	Yes		No
426	SHEET	SHEET	Exact Match	SHEET	Yes		No
427	SHEETS	SHEETS	Exact Match	SHEETS	Yes		No
428	SIGN	SIGN	Exact Match	SIGN	Yes		No
429	SIN	SIN	Exact Match	SIN	Yes		No
430	SINH	SINH	Exact Match	SINH	Yes		No
431	SKEW	SKEW	Exact Match	SKEW	Yes		No
432	SKEW.P	SKEW.P	Exact Match	SKEW.P	Yes		No
433	SLN	SLN	Exact Match	SLN	Yes		No
434	SLOPE	SLOPE	Exact Match	SLOPE	Yes		No
435	SMALL	SMALL	Exact Match	SMALL	Yes		No
436	SORT	SORT	Exact Match	SORT	Yes		No
437	SORTBY	SORTBY	Exact Match	SORTBY	Yes		No
438		SPLIT	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
439	SQRT	SQRT	Exact Match	SQRT	Yes		No
440	SQRTPI	SQRTPI	Exact Match	SQRTPI	Yes		No
441	STANDARDIZE	STANDARDIZE	Exact Match	STANDARDIZE	Yes		No
442	STDEV (Legacy)	STDEV	Name Mismatch	STDEV	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
443	STDEV.P		Alias Duplicate Row	STDEVP	Yes		No	Not a gap - Zoho has this as STDEVP, already recorded on Sno 446.
444	STDEV.S		Semantic Equivalent	STDEV	Yes		No	Identical function under legacy name.
445	STDEVA	STDEVA	Exact Match	STDEVA	Yes		No
446	STDEVP (Legacy)	STDEVP	Name Mismatch	STDEVP	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
447	STDEVPA	STDEVPA	Exact Match	STDEVPA	Yes		No
448	STEYX	STEYX	Exact Match	STEYX	Yes		No
449		STOCK	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
450	STOCKHISTORY		Missing in Zoho		No	External/Web Data	No
451	SUBSTITUTE	SUBSTITUTE	Exact Match	SUBSTITUTE	Yes		No
452	SUBTOTAL	SUBTOTAL	Exact Match	SUBTOTAL	Yes		No
453	SUM	SUM	Exact Match	SUM	Yes		No
454	SUMIF	SUMIF	Exact Match	SUMIF	Yes		No
455	SUMIFS	SUMIFS	Exact Match	SUMIFS	Yes		No
456	SUMPRODUCT	SUMPRODUCT	Exact Match	SUMPRODUCT	Yes		No
457	SUMSQ	SUMSQ	Exact Match	SUMSQ	Yes		No
458	SUMX2MY2	SUMX2MY2	Exact Match	SUMX2MY2	Yes		No
459	SUMX2PY2	SUMX2PY2	Exact Match	SUMX2PY2	Yes		No
460	SUMXMY2	SUMXMY2	Exact Match	SUMXMY2	Yes		No
461	SWITCH	SWITCH	Exact Match	SWITCH	Yes		No
462	SYD	SYD	Exact Match	SYD	Yes		No
463	T	T	Exact Match	T	Yes		No
464	T.DIST		Alias Duplicate Row	TDIST	Yes		No	Not a gap - Zoho has this as TDIST, already recorded on Sno 476.
465	T.DIST.2T	T.DIST.2T	Exact Match	T.DIST.2T	Yes		No
466	T.DIST.RT	T.DIST.RT	Exact Match	T.DIST.RT	Yes		No
467	T.INV		Alias Duplicate Row	TINV	Yes		No	Not a gap - Zoho has this as TINV, already recorded on Sno 484.
468	T.INV.2T	T.INV.2T	Exact Match	T.INV.2T	Yes		No
469	T.TEST		Alias Duplicate Row	TTEST	Yes		No	Not a gap - Zoho has this as TTEST, already recorded on Sno 497.
470	TAKE	TAKE	Exact Match	TAKE	Yes		No
471	TAN	TAN	Exact Match	TAN	Yes		No
472	TANH	TANH	Exact Match	TANH	Yes		No
473	TBILLEQ	TBILLEQ	Exact Match	TBILLEQ	Yes		No
474	TBILLPRICE	TBILLPRICE	Exact Match	TBILLPRICE	Yes		No
475	TBILLYIELD	TBILLYIELD	Exact Match	TBILLYIELD	Yes		No
476	TDIST (Legacy)	TDIST	Name Mismatch	TDIST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
477	TEXT	TEXT	Exact Match	TEXT	Yes		No
478	TEXTAFTER	TEXTAFTER	Exact Match	TEXTAFTER	Yes		No
479	TEXTBEFORE	TEXTBEFORE	Exact Match	TEXTBEFORE	Yes		No
480	TEXTJOIN	TEXTJOIN	Exact Match	TEXTJOIN	Yes		No
481	TEXTSPLIT	TEXTSPLIT	Exact Match	TEXTSPLIT	Yes		No
482	TIME	TIME	Exact Match	TIME	Yes		No
483	TIMEVALUE	TIMEVALUE	Exact Match	TIMEVALUE	Yes		No
484	TINV (Legacy)	TINV	Name Mismatch	TINV	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
485	TOCOL	TOCOL	Exact Match	TOCOL	Yes		No
486	TODAY	TODAY	Exact Match	TODAY	Yes		No
487		TOP	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
488	TOROW	TOROW	Exact Match	TOROW	Yes		No
489	TRANSLATE		Missing in Zoho		No	Modern Excel (2023+)	No
490	TRANSPOSE	TRANSPOSE	Exact Match	TRANSPOSE	Yes		No
491	TREND	TREND	Exact Match	TREND	Yes		No
492	TRIM	TRIM	Exact Match	TRIM	Yes		No
493	TRIMMEAN	TRIMMEAN	Exact Match	TRIMMEAN	Yes		No
494	TRIMRANGE		Missing in Zoho		No	Modern Excel (2023+)	No
495	TRUE	TRUE	Exact Match	TRUE	Yes		No
496	TRUNC	TRUNC	Exact Match	TRUNC	Yes		No
497	TTEST (Legacy)	TTEST	Name Mismatch	TTEST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
498	TYPE	TYPE	Exact Match	TYPE	Yes		No
499	UNICHAR	UNICHAR	Exact Match	UNICHAR	Yes		No
500	UNICODE		Missing in Zoho		No	Misc	No
501	UNIQUE	UNIQUE	Exact Match	UNIQUE	Yes		No
502	UPPER	UPPER	Exact Match	UPPER	Yes		No
503	VALUE	VALUE	Exact Match	VALUE	Yes		No
504	VALUETOTEXT	VALUETOTEXT	Exact Match	VALUETOTEXT	Yes		No
505	VAR (Legacy)	VAR	Name Mismatch	VAR	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
506	VAR.P		Alias Duplicate Row	VARP	Yes		No	Not a gap - Zoho has this as VARP, already recorded on Sno 509.
507	VAR.S		Semantic Equivalent	VAR	Yes		No	Identical function under legacy name.
508	VARA	VARA	Exact Match	VARA	Yes		No
509	VARP (Legacy)	VARP	Name Mismatch	VARP	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
510	VARPA	VARPA	Exact Match	VARPA	Yes		No
511	VDB	VDB	Exact Match	VDB	Yes		No
512	VLOOKUP	VLOOKUP	Exact Match	VLOOKUP	Yes		No
513	VSTACK	VSTACK	Exact Match	VSTACK	Yes		No
514	WEBSERVICE		Missing in Zoho		No	External/Web Data	No
515	WEEKDAY	WEEKDAY	Exact Match	WEEKDAY	Yes		No
516	WEEKNUM	WEEKNUM	Exact Match	WEEKNUM	Yes		No
517		WEEKNUM_ADD	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
518		WEEKS	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
519		WEEKSINYEAR	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
520	WEIBULL (Legacy)	WEIBULL	Name Mismatch	WEIBULL	Yes		Yes	Same function, different spelling (dotted vs. legacy name).
521	WEIBULL.DIST		Semantic Equivalent	WEIBULL	Yes		No	Identical function under legacy name.
522	WORKDAY	WORKDAY	Exact Match	WORKDAY	Yes		No
523	WORKDAY.INTL	WORKDAY.INTL	Exact Match	WORKDAY.INTL	Yes		No
524	WRAPCOLS	WRAPCOLS	Exact Match	WRAPCOLS	Yes		No
525	WRAPROWS	WRAPROWS	Exact Match	WRAPROWS	Yes		No
526	XIRR	XIRR	Exact Match	XIRR	Yes		No
527	XLOOKUP	XLOOKUP	Exact Match	XLOOKUP	Yes		No
528	XMATCH	XMATCH	Exact Match	XMATCH	Yes		No
529	XNPV	XNPV	Exact Match	XNPV	Yes		No
530	XOR	XOR	Exact Match	XOR	Yes		No
531	YEAR	YEAR	Exact Match	YEAR	Yes		No
532	YEARFRAC	YEARFRAC	Exact Match	YEARFRAC	Yes		No
533		YEARS	Zoho Only				No	Zoho Sheet function with no Excel counterpart.
534	YIELD	YIELD	Exact Match	YIELD	Yes		No
535	YIELDDISC	YIELDDISC	Exact Match	YIELDDISC	Yes		No
536	YIELDMAT	YIELDMAT	Exact Match	YIELDMAT	Yes		No
537	Z.TEST		Alias Duplicate Row	ZTEST	Yes		No	Not a gap - Zoho has this as ZTEST, already recorded on Sno 538.
538	ZTEST (Legacy)	ZTEST	Name Mismatch	ZTEST	Yes		Yes	Same function, different spelling (dotted vs. legacy name).