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),"")
Fields showing NO on Calculated Column
Viewed 30
1 Answers
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
Related