I did all the formulas correct for Bonus, Car, Medical but when it ask me total for Sales department for December 2020 and I entered XXXXXX for phone cost. It gives me incorrect answer. No sure were I went wrong. How do I trace back?
One thing I noticed at right top corner it is displaying actual figure and in the cell it is displaying rounded figure. Is that the issue?
You don't need to multiply the expenses by the salary. Only bonus.
As a courtesy though, try not to post exam answers on the forum. We want to make sure we provide guidance but not direct answers.
You got this!
I will keep that in mind for next post. Sorry didn't mean to expose the answer. Thanks for your prompt response. Let me check and will let you know.