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 selected place (O4) is higher than 0.8, assign "Strong"; if it's higher than 0.6, make it "Moderate" etc.
I keep getting the "There's a problem with this formula" message. No clues are given as to what might be wrong. Any thoughts?
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"; "")))
2 Replies
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! 🙂
