Dec 21 2021 11:29 AM - edited Dec 21 2021 11:34 AM
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!