Getting Error upon Putting IF ELSE Function

Question

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.

Book1.xlsx

RaphaelSilva · Accepted Answer

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

RaphaelSilva · Accepted Answer

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 Answer

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

RaphaelSilva · Accepted Answer

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