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.
SUBSTITUEThe 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.
SUBSTITUE
The text string after replacing instances of a substring.

Have Case Sensitive Option

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.
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

AVERAGEIFSThe arithmetic mean of all the numbers in a range that satisfies multiple conditions.
COUNTIFSThe number of non blank cells that satisfies multiple conditions.
SUMIFSThe total value of the numbers that satisfies multiple conditions.
MINIFSThe smallest value in a list or array of numbers that satisfies multiple conditions.
MAXIFSThe largest value in a list or array of numbers that satisfies multiple conditions.
AVERAGEIFThe arithmetic mean of all the numbers in a range that satisfies one condition.
COUNTIFThe number of non blank cells that satisfies one condition.
SUMIFThe total value of the numbers that satisfies one condition.
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.
VLOOKUPThe value in the same row after finding a matching value in the first column.
HLOOKUPThe value in the same column after finding a matching value in the first row.
REPLACEThe text string after replacing characters in a specific location.
SEARCHThe position of a substring within a larger text string.
IFThe value based on a logical test that is either True or False.
IFSThe value based on multiple True or False conditions.
ANDThe logical AND for any number of arguments.
ORThe logical OR for any number of arguments.
NOTThe opposite of a True or False value.
XORThe logical exclusive OR for any number of arguments.
AVERAGEIFS
The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
COUNTIFS
The number of non blank cells that satisfies multiple conditions.
SUMIFS
The total value of the numbers that satisfies multiple conditions.
MINIFS
The smallest value in a list or array of numbers that satisfies multiple conditions.
MAXIFS
The largest value in a list or array of numbers that satisfies multiple conditions.
AVERAGEIF
The arithmetic mean of all the numbers in a range that satisfies one condition.
COUNTIF
The number of non blank cells that satisfies one condition.
SUMIF
The total value of the numbers that satisfies one condition.
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.
VLOOKUP
The value in the same row after finding a matching value in the first column.
HLOOKUP
The value in the same column after finding a matching value in the first row.
REPLACE
The text string after replacing characters in a specific location.
SEARCH
The position of a substring within a larger text string.
IF
The value based on a logical test that is either True or False.
IFS
The value based on multiple True or False conditions.
AND
The logical AND for any number of arguments.
OR
The logical OR for any number of arguments.
NOT
The opposite of a True or False value.
XOR
The logical exclusive OR for any number of arguments.

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