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.
Download Cars Data File: drive.google.com/uc?export=do...
The Burkey Bytes Excel Playlist: • Short Excel 1: Cells, ...
Playlist with more Excel Videos: • Excel Videos
My Website: www.burkeyacademy.com/
Support me on Patreon! / burkeyacademy
Talk to me on my SubReddit: / burkeyacademy
Buy me a cup of coffee on PayPal? paypal.me/BurkeyAcademy

[@martinbuckland5746]

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

[@BurkeyAcademy]

You can use the LEFT command. =LEFT(A2,3) extracts the first 3 characters in cell A2.

[@martinbuckland5746]

can you pls help me with a file?