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

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

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

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

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

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

XOR | The logical exclusive OR for any number of arguments. |

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

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