what is the if formula in excel?
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. ... For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).