Getting Error upon Putting IF ELSE Function

[duttaabhishek]

Hi I have a dataset with country names and the associated Score in each country. I am trying to input IF THEN ELSE within the FOrmula Tool to generate the Rating as per the score. However I am getting an error. Not sure why the error is coming. 

I am attaching the data set and the IF ELSE conditions within the same sheet. Can anyone please help.

[RaphaelSilva · Accepted solution]

You can use the RegEx tool to parse the values, see sample workflow

[RaphaelSilva · Accepted solution]

If you really want to do using Formula tool, I have attached sample as well, but it is using Regex in the formulas anyway
Yet, if you want to use IF Condition, you can look for last digits using RIGHT and check if that's a number of not, things like that, but that would be way much more complicated for no reason.
I did not find the IF Condition you tried to use in the excel file

[duttaabhishek · Accepted solution]

Thanks for your iput. This was helpful thanks a lot again.

[RaphaelSilva · Accepted solution]

Happy to help @duttaabhishek 
If you can mark as solution it would motivate me helping the community :)