Fields showing NO on Calculated Column

Question

Here is the formula I am using in calculated column, but it shows value no on column field:

=IF(ISERROR([Sep 22]/[Useful Life (in Years)]/12),"")

Answer 1

Syntax of IF function is like: IF(<condition>, <true-value>, <false-value>). You are missing <false-value> in your formula.

Try using formula like below:

=IF(ISERROR(([Sep 22]/[Useful Life (in Years)])/12), "Error", "No Error")

Documentation: Examples of common formulas in lists