Forum Discussion
Solved
IF formula giving an error
I'm using the following nested formula for assigning different values based on a threshold percentage: =IF(O4>0.8;"Strong";IF(O4>0.6;"Moderate";IF(O4>0.4;"Weak"; ""))) If a result in the sel...
Since you use point as decimal separator, you should use comma instead of semicolon to separate the arguments of the functions:
=IF(O4>0.8, "Strong", IF(O4>0.6, "Moderate", IF(O4>0.4, "Weak", "")))
Or alternatively, if you use comma as decimal separator, change the numbers in the formula:
=IF(O4>0,8; "Strong"; IF(O4>0,6; "Moderate"; IF(O4>0,4; "Weak"; "")))
Since you use point as decimal separator, you should use comma instead of semicolon to separate the arguments of the functions:
=IF(O4>0.8, "Strong", IF(O4>0.6, "Moderate", IF(O4>0.4, "Weak", "")))
Or alternatively, if you use comma as decimal separator, change the numbers in the formula:
=IF(O4>0,8; "Strong"; IF(O4>0,6; "Moderate"; IF(O4>0,4; "Weak"; "")))
- Thanks a bunch! The second option worked! 🙂
