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

EXACTThe value True or False based on whether two strings match exactly.
FINDThe position of a substring within a larger text string.
SUBSTITUTEThe 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 Case Sensitive Option

TEXTAFTERThe characters from the end of a text string after a delimiter.
TEXTBEFOREThe characters from the start of a text string before a delimiter.
XLOOKUPThe value in the same row after finding a matching value in any column.
XMATCHThe position of a value in a list, table or cell range.
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.
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.

Not Case Sensitive

ANDThe logical AND for any number of arguments.
AVERAGEIFThe arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFSThe arithmetic mean of all the numbers in a range that satisfies multiple conditions.
COUNTIFThe number of non blank cells that satisfies one condition.
COUNTIFSThe number of non blank cells that satisfies multiple conditions.
FILTERThe array after filtering data in a range that satisfies multiple conditions.
HLOOKUPThe value in the same column after finding a matching value in the first row.
IFThe value based on a logical test that is True or False.
IFSThe value based on multiple True or False conditions.
LOOKUPThe value in a row (or column) that matches a value in a column (or row).
MATCHThe position of a value in a list, table or cell range.
MAXIFSThe largest value in a list or array of numbers that satisfies multiple conditions.
MINIFSThe smallest value in a list or array of numbers that satisfies multiple conditions.
NOTThe opposite of a True or False value.
ORThe logical OR for any number of arguments.
REPLACEThe text string after replacing characters in a specific location.
SEARCHThe position of a substring within a larger text string.
SUMIFThe total value of the numbers that satisfies one condition.
SUMIFSThe total value of the numbers that satisfies multiple conditions.
SWITCHThe value based on the first matching item.
VLOOKUPThe value in the same row after finding a matching value in the first column.
XORThe 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.
XOR
The logical exclusive OR for any number of arguments.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext