IF Formula trouble SharePoint Column

[DKoh]

Hi

I have a column (Project Request) with numbers from 0-7

My Formula should give the Output like this

A= >5

B= >2

C= <2

i try to create a new calculated column  with this Formula, but i get an error every time.

=IF([Project Request Index]>5,"A",IF([Project Request Index]>2,"B","C"))

what is wrong here? 

it should be simple

[#2]

H! I assume your Project request column is a number column. And the result type of your calculated column should be a text column.

With a flow in ms flow you could also do a switch action for your sp column, without that nested if functions. In my eyes it is more reliable than a calculated file. Trigger could be when an item is created or changed. And calculation could be written in variable so it’s more performant.

Greets, Eva

[#3 · Accepted solution]

No unfortunately not

But i found my mistake.

I must use ; between the Expressions.

I think my Problem is here i switch from englisch - german and back ;)