Case Sensitive Functions

The following is a list of functions that are case sensitive.
It also includes a list of functions that can be both (because they include an optional parameter)
And a list of functions that are not case sensitive.

Are Case Sensitive

EXACT	The value True or False based on whether two strings match exactly.
FIND	The position of a substring within a larger text string.
SUBSTITUTE	The text string after replacing instances of a substring.

EXACT The value True or False based on whether two strings match exactly.
FIND The position of a substring within a larger text string.
SUBSTITUTE The text string after replacing instances of a substring.

Have A Case Sensitive Option

TEXTAFTER	The characters from the end of a text string after a delimiter.
TEXTBEFORE	The characters from the start of a text string before a delimiter.

TEXTAFTER The characters from the end of a text string after a delimiter.
TEXTBEFORE The characters from the start of a text string before a delimiter.

Not Case Sensitive

AND	The logical AND for any number of arguments.
AVERAGEIF	The arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFS	The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
COUNTIF	The number of non blank cells that satisfies one condition.
COUNTIFS	The number of non blank cells that satisfies multiple conditions.
FILTER	The array after filtering data in a range that satisfies multiple conditions.
HLOOKUP	The value in the same column after finding a matching value in the first row.
IF	The value based on a logical test that is True or False.
IFS	The value based on multiple True or False conditions.
LOOKUP	The value in a row (or column) that matches a value in a column (or row).
MATCH	The position of a value in a list, table or cell range.
MAXIFS	The largest value in a list or array of numbers that satisfies multiple conditions.
MINIFS	The smallest value in a list or array of numbers that satisfies multiple conditions.
NOT	The opposite of a True or False value.
OR	The logical OR for any number of arguments.
REPLACE	The text string after replacing characters in a specific location.
SEARCH	The position of a substring within a larger text string.
SUMIF	The total value of the numbers that satisfies one condition.
SUMIFS	The total value of the numbers that satisfies multiple conditions.
SWITCH	The value based on the first matching item.
VLOOKUP	The value in the same row after finding a matching value in the first column.
XLOOKUP	The value in the same row after finding a matching value in any column.
XMATCH	The position of a value in a list, table or cell range.
XOR	The logical exclusive OR for any number of arguments.

AND The logical AND for any number of arguments.
AVERAGEIF The arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFS The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
COUNTIF The number of non blank cells that satisfies one condition.
COUNTIFS The number of non blank cells that satisfies multiple conditions.
FILTER The array after filtering data in a range that satisfies multiple conditions.
HLOOKUP The value in the same column after finding a matching value in the first row.
IF The value based on a logical test that is True or False.
IFS The value based on multiple True or False conditions.
LOOKUP The value in a row (or column) that matches a value in a column (or row).
MATCH The position of a value in a list, table or cell range.
MAXIFS The largest value in a list or array of numbers that satisfies multiple conditions.
MINIFS The smallest value in a list or array of numbers that satisfies multiple conditions.
NOT The opposite of a True or False value.
OR The logical OR for any number of arguments.
REPLACE The text string after replacing characters in a specific location.
SEARCH The position of a substring within a larger text string.
SUMIF The total value of the numbers that satisfies one condition.
SUMIFS The total value of the numbers that satisfies multiple conditions.
SWITCH The value based on the first matching item.
VLOOKUP The value in the same row after finding a matching value in the first column.
XLOOKUP The value in the same row after finding a matching value in any column.
XMATCH The position of a value in a list, table or cell range.
XOR The logical exclusive OR for any number of arguments.