Last answered:

19 Nov 2022

Posted on:

17 Nov 2022

0

Don't understand why am i getting error in some cells while others are responding fine.





image.png

3 answers ( 0 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

18 Nov 2022

0

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.

image.png
Regards,

Kev T.

Posted on:

19 Nov 2022

0

image.png

Posted on:

19 Nov 2022

2

Kev Tomlinson

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.

Submit an answer