IF formula giving an error

[niknik11]

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?

[#2 · Accepted solution]

@niknik11 

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"; "")))

[#3]

Thanks a bunch! The second option worked! :)