Hi Im Kersbots from Botswana.

[Kersbots]

Good Day "Dumela"
I am busy trying to design a simple spreadsheet for my boss and having a problem because it shows #N/A in the cells which the formula refers to before the values have been entrered.
Is there any way I can stop it displaying the error message?

[bonny24tycoon]

Welcome to the forum

Yes, you can stop the error. Can you let me know what the formula is in a cell?


If I was able to help – PLEASE DO NOT FORGET to Click the small star icon at the bottom left of my post.

[Paul]

Hi Kersbots, welcome to the forum.

Please take a moment to read the forum rules - link in my signature below - and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

I've moved your thread from the Introduce Yourself forum to a proper question forum. Please post your questions in the appropriate sub-forum(s) in the future.

Thank you.