Short Excel 7: If, AND, OR, NOT, and Ifs Commands
Рет қаралды 1,589
2 жыл бұрын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 2 жыл бұрын
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 2 жыл бұрын
You can use the LEFT command. =LEFT(A2,3) extracts the first 3 characters in cell A2.
@martinbuckland5746 2 жыл бұрын
can you pls help me with a file?
Leila Gharani
Рет қаралды 3,5 МЛН
Chester Tugwell
Рет қаралды 3,9 М.