igin Fle Home InsertDraw Page Layout Formulas Painting Use the IF function to ea

Question

igin Fle Home InsertDraw Page Layout Formulas Painting Use the IF function to earns an outcome bonus (the corresponding cell in the "Outcome Bonus?" column is TRUE), then "Outcome Bonus $" is the "Job Pay" for that project times the outcome bonus percentage in cell M12 Otherwise "Outcome Bonus $" is 014 points] complete the "Outcome Bonus $" column of Table 1. If an employee M12 882 51.72 2,746 2100 Four )s Painting Google Event Profit Past Events Pivottable Questions PT PT2 PT3 Type here to search

Explanation / Answer

Row number is not visible in the snapshot, I will assume this row number is 16 (since the row 11 is the bonus % row)

if ($J16="YES", K11*$M$12,0)

Put this formula in M16 cell and drag it to the bottom.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.