#### Snehit Sah

##### Broken In

I was watching a tutorial on GMetrix on YouTube. There is a question for which I'm not sure about the answer. Neither do I find the instructor's method to be correct. I have attached a screenshot of the question with this thread.

In the question, 'Quarterly Goal' refers to cell B18, having a value of $100,000. 'Quarterly Bonus Rate' refers to cell B17, having a value of 2%.

To see how the instructor attempted the question, go to the link on YouTube : Moderator edit: Removed link.

He is using the sumif function, which I don't find logical. But I also don't know what should be the correct answer.

Can anyone experienced in MS Excel please help me out! I'm preparing for an exam which is due in two days.

Thank You!

In the question, 'Quarterly Goal' refers to cell B18, having a value of $100,000. 'Quarterly Bonus Rate' refers to cell B17, having a value of 2%.

To see how the instructor attempted the question, go to the link on YouTube : Moderator edit: Removed link.

He is using the sumif function, which I don't find logical. But I also don't know what should be the correct answer.

Can anyone experienced in MS Excel please help me out! I'm preparing for an exam which is due in two days.

Thank You!

#### Attachments

Last edited by a moderator: