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

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

SUBSTITUEThe text string after replacing instances of a substring. |

#### Have Case Sensitive Option

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

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

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

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

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