#N/A means “not available” or “no value available”.
you could use the NA function to display the #N/A error when information is missing.
The NA function takes no arguments.
If so, IF returns NA(), which returns the #N/A error.
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
