Excel's IF functions are an essential tool for analysis.
A statement in an IF formula helps you make logical comparisons between a value and what you expect, and can have two results. The first result is if your comparison is True. The second (if needed) result, separated from the first…