Force #N/A error in cell

This may seem illogical, and we even asked ourselves why anybody would want to do this, when the whole point of a clean and fully functional excel project is to avoid errors and ensure nothing can get in the way of an accurate result or outcome.

However, we were asked to create a formula that would force a ‘#N/A’ error into a cell and actually be recognised as an error rather than just the text ‘#N/A’. This was important to ensure the project behaved as required. We could see the reason behind the request once we had created it, and it may be that these errors do have a place in projects where required. The example is below for all to see, and possibly still wonder why !?

Feel free to contact us regarding this project, or leave a comment below.

=if(A1=”OK”,”All good”,#N/A)

Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us