Help Q Comm Home 27% 42 Thu 1:12 AM Q AutoSave e Etus. HW6 done --- Saved to my Mac Insert Draw Page Layout Formulas Data Review >> Tell me Share % Conditional Formatting Ou 8 Formatos Table Alignment Number Cells Ediding Ideas Cell Styles fx I am lost on this problem. I need help! A Paste Font A20 B C D E F H 1 Eyes Handednes Blue/Right 2 Blue Left TRUE 3 Brown Left TRUE 4 Blue Right TRUE 5 Green Right TRUE 6 7 8 Criteria Create a copyable IF function in cell C2 that includes either the AND or 9 Blue the OR function to decide if individuals get a $500 or $1000 bonus 10 Right based on the information in the next paragraph. Autofill/copy this 11 function to cells C3 through CS 12 13 Bonus Per the criteria table, any person who has BLUE eyes and is RIGHT 14 500 handed will get a 1000 bonus otherwise they get a 500 bonus. 15 1000 Do not hardcode anything. Format as appropriate. 16 17 10 points 18 19 20 I am lost on this problem. I need help! 21 22 Prob 1 Sheaths Prize AND OR + ER 1 W Ps