Learn how to use the IF function, one of the most popular functions in Microsoft Excel. The IF function allows you to make logical comparisons between a value and what you expect.
An IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).
Microsoft support article on using the IF Function: https://support.office.com/en-us/arti…
Access the sample data that I use in this video here: https://1drv.ms/x/s!AmxrofZZlZ-whIZwd…
Kevin Stratvert 