EA7-C1 Discuss Using the IF Function The IF function is one of the most versatile functions available in Excel. Even the simplest IF function can add great benefit to a worksheet. In this chapter, you saw how the IF function can be used in a payroll register to ensure that correct earnings and withholding amounts are entered for each employee. However, the payroll register is not the only accounting-related worksheet within which the IF function can be used. Identify three types of accounting worksheets (other than the payroll register) that can benefit from the use of the IF function. Write a paragraph of at least five sentences in which you iden- tify these worksheets. Write a second paragraph of at least five sentences to discuss how the IF function can be used within each worksheet and why it would be beneficial to do so