If something is true, then do this, else/otherwise do that. For example, ... Use a nested IF statement to calculate different commissions based on different percentages. 6.