Short Excel 7: If, AND, OR, NOT, and Ifs Commands

Here I show you some examples of using IF commands in Excel. I also show how to include AND, OR, and NOT, and finish with the very cool IFS command.

These Videos use Excel for Microsoft 365 version 2106, on a Windows machine. Other versions may look or behave a little differently.

[RA-rhlb]

Wow, you have explained meaningful business scenarios with multiple conditions so well. I was expecting a little more that was a combination of (Ifs with OR/AND combo). Do you have any videos where you used ifs/ifs with OR and AND combinations? thanks

[martinbuckland]

how would i use if function to check the first 3 letters/numbers match not the whole number
IE E11-2K E12-2K, i only what to see if E11 and E12 match