Learn how to use the IF function, one of the most popular functions in Microsoft Excel. The IF function allows you to logically compare a value and what you expect. An IF statement can have two results.
The first result is if your comparison is True, and the second is if your comparison is False.
For example, =IF(C4=”Yes”,"First","Second") says IF(C2 = Yes, then return a First, otherwise return a Second).
Microsoft support article on using the IF Function: https://support.microsoft.com/en-us/o...
Access the sample data that I use in this video here: https://docs.google.com/spreadsheets/...