Excel-6 is a guide to logical functions in Microsoft Excel. Here you'll find practical tips, instructions, and illustrations about working with IF, AND, OR, NOT, XOR, IFS, and SWITCH functions.
📚 Goal: Help you master logical functions in Excel for smarter, more efficient spreadsheets—suitable for both beginners and advanced users!
- IF Function
- AND Function
- OR Function
- NOT Function
- XOR Function
- IF with AND Example
- Comparison Operators
- IFS Function
- SWITCH Function
- Screenshots
- Requirements
- Author
The IF function checks whether a condition is met and returns one value if TRUE and another value if FALSE.
The AND function returns TRUE if all conditions are TRUE and FALSE if any condition is FALSE.
The OR function returns TRUE if any condition is TRUE and FALSE if all conditions are FALSE.
The NOT function reverses logic: TRUE becomes FALSE, and FALSE becomes TRUE.
The XOR function returns TRUE if an odd number of conditions are TRUE, and FALSE otherwise.
Check if both start and end values are not empty, then subtract them.
<>means "not equal to"- If any value is empty, returns an empty string.
=means equal to
>means greater than
<means less than
>=means greater than or equal to,<=means less than or equal to
Use the IFS function in Excel 2016 or later when you have multiple conditions to check. Returns the value for the first TRUE condition.
The SWITCH function looks up a value from a list and returns the result for the first match found.
- The RIGHT function extracts the 2 rightmost characters from the string.
You can find all screenshots in the /Screenshots folder.
- Microsoft Excel (recommended: 2016 or newer for IFS and SWITCH)
- Windows OS
Project and documentation by Kuba27x
Repository: Kuba27x/Excel-6