IF syntax error, The formula contains a syntax error or is not supported.

New Contributor

Hi!

I have a sharepoint list with several columns.
One column is called "PesoPriorizacion" and, it is a percentage (%) field.

Another column will be called "Quintiles" and will be a calculated field based on 'PesoPriorizacion". I have the following formula:

 

=IF([PesoPriorizacion]>81%,1,IF[PesoPriorizacion]>61%,2,IF[PesoPriorizacion]>41%,3,IF[PesoPriorizacion]>21%,4,5))))

 

However, the sharepoint list throws me a syntax error and, I don't understand what could be the error.
I will be attentive, thank you very much!

0 Replies