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?
@abhishah
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.
