is there a way to replace #value with another value such as "N/A"

[kckar]

is there any way to do this using an if statement

i have a column that contains data like d74 d99 e67 ext typ. the values that contain a letter followed by a number are important to me so i tried to create an if statement that would only calculate rows with one letter followed by a number, and exclude those without but i dont know the value for #value

[jasoncw]

=IF(ISERROR(your_formula),"N/A",your_formula)