Welcome to KnowledgeVarsity Forum! This Forum is to answer your queries regarding question text and its instructions for this specific question. Please take a minute before posting a question and see if you can find an answer to your question. If not, please post your question. The Forum moderator will respond very soon!
Step 17, Table 8, After Tax Bonus: The sales manager would like to know the after tax bonus to be paid on the basis of commission computed in Table 7.
Assume that all salesperson are paid bonus (cell B67) and all of them are in the same marginal tax rate (cell B68).
He has created Table 8 (A70:E79) and he wants you to write the formula to compute the after tax bonus amount.
(a) Write a Smart formula in cell A71, copy it down to A79 and copy it across to E79.
You should write a formula such that when the formula is copied, it computes the after tax bonus amount correctly.
Do not hardcode values in formula, refer cells.
(b) Apply Conditional Formatting to the range A71:E79, Apply Green - Yellow - Red color scale
There doesn’t seem to be enough information to solve this. Please review and advise.
We will review and update the MiniCase with appropriate formula to compute the after tax bonus.