For the following data set, use an IF statement with an embedded AND statement to determine if an employee will be paid a bonus. To receive a bonus an employee must have over $200000 in sales and have no more than 2 days absent. Your IF statement must display a statement indicating if a bonus will be paid to the employee or if no bonus will be paid. Employee Days Total Sales Absent $ Dee 3 300000 Sue 5 250000 190000 Lilly Carmen 7 2. 375000 Doug 0 450000 Barb 1 225000 Kate 3 100000 Usha 1 175000 Safi 2. 625000 Aali 0 500000 Terrence 4. 200000 Phil 1 335000 To copy text you have to Paste > Special(text)