The Excel IF function can help you when you have a lot of basic decisions to make. Has a sales person reached their bonus or not? Are the stock levels low? Is a cell value empty? The excel IF function can return an answer based on simple logic criteria.
This free online IT training video will show you how to use the excel IF function to calculate the bonus of sales persons if they reach a certain target.
You may have to click on enable editing in Excel to be able to complete the exercise.