The IF formula displays a result, depending on whether or not a criteria is met. The result displayed by the IF formula can also be another formula or a calculation. Calculate the amount of bonus if the target has been achieved Bonus Bonus Amount True/False 6% 7% Employee Bruce Banner Scott Lang Peter Parker Steve Rogers Natalia Romanoff Tony Stark Salary Sales Target $ 57,464.00 $ 234,234.00 $ 221,000.00 $ 82,789.00 $ 230,587.00 $ 250,000.00 $ 75,612.00 $ 260,850.00 $ 210,000.00 $ 67,514.00 $ 187,000.00 $ 180,000.00 $ 73,356.00 $ 165,345.00 $ 150,000.00 $ 64,828.00 $ 180,500.00 $ 195,000.00 7% 5% 7% 8% Combining IF and AND By using the AND formula it is possible to specify multiple conditions, both of which should be met. Employees are due a bonus if the make more than $60,000 and if they achieve their target. Indicate whether the employee is due a bonus with "True" or "False" Calculate the amount of bonus if the salary exceeds 60 grand AND the target has been achieved Salary Bonus Bonus Amount True/False 6% 7% Staff member Bruce Banner Scott Lang Peter Parker Steve Rogers Natalia Romanoff Tony Stark Sales Target $ 57,464.00 $ 234,234.00 $ 221,000.00 $ 82,789.00 $ 230,587.00 $ 250,000.00 $ 75,612.00 $ 260,850.00 $ 210,000.00 $ 67,514.00 $ 187,000.00 $ 180,000.00 $ 73,356.00 $ 165,345.00 $ 150,000.00 $ 64,828.00 $ 180,500.00 $ 195,000.00 7% 5% 7% 8%