Don't understand why am i getting error in some cells while others are responding fine.
Hi Muhammad Ali Jafri,
This will be a bit of a guess BUT another colleague had virtually the same errors you have shown. If this doesn't fix your errors, provide a screenshot of the formula in the 'error' cell and I will take another look.
If you are using the worksheets provided for the course, there is a 'spacer' row between Volume and Gross Sales Income, so $B7 references an empty cell. I suggest it should be $B8 - see if that works.
That dose not seems to be the case, as for the rest of the cells i had to convert them from General to numbers, I have done the same with all of them but nothing seems to be working.