IF formula Unparseable error when using strings
Not sure what is going wrong here, as I’m getting UNPARSEABLE error when using the formula below.
=IF([Risk Rating Calculation]@row<5,”yes”,”no”)
If I were to use numbers instead of the strings “yes” and “no” I do not get any errors (example below).
=IF([Risk Rating Calculation]@row<5,12,10) -> This does not give any errors and works as expected
All the syntax seems to be matching what is shown in the examples as well… Any suggestions?
Help Article Resources
Check out the Formula Handbook template!