# Calculated column Multiple with multiple IF(IF()) error

Good morning people. I'm sorry but I need your help.

I have tried to create a calculated column in SharePoint list, depending on two values ​​"height" and "area" corresponds to a number.

I tried the following:

``````IF(AND([Área]<=10;[Alto]<=2);2;IF(AND([Área]<=20;[Alto]<=2);3;IF(AND([Área]<=30;[Alto]<=2);4;IF(AND([Área]>30;[Alto]<=2);5;IF(AND([Alto]<=4;[Área]<=10);6;IF(AND([Alto]<=4;[Área]<=20);7;IF(AND([Alto]<=4;[Área]<=30);8;IF(AND([Alto]<=4;[Área]>30);9;IF(AND([Alto]<=10;[Área]<=10);10;IF(AND([Alto]<=10;[Área]<=20);11;IF(AND([Alto]<=10;[Área]<=30);12;IF(AND([Alto]<=10;[Área]>30);13;IF(AND([Alto]<=20;[Área]<=10);14;IF(AND([Alto]<=20;[Área]<=20);15;IF(AND([Alto]<=20;[Área]<=30);16;IF(AND([Alto]<=20;[Área]>30);17;IF(AND([Alto]>20;[Área]<=10);18;IF(AND([Alto]>20;[Área]<=20);19;IF(AND([Alto]>20;[Área]<=30);20;IF(AND([Alto]>20;[Área]>30);21;))))))))))))))))))))
``````

I don't know if there is any syntax error, SharePoint doesn't notify me of that.

• Are you not getting expected results while using this formula? Can you add/explain the conditions/logic you are looking for? Feb 1 at 11:46
• Also, you are trying to use 20 nested `IF` functions which is not supported in SharePoint. Check this and this for possible workarounds. let me know if it works for you. Feb 1 at 11:52
• I didn't know there were only 19 nested if conditions. Thank you very much, I'll try that change in a moment Feb 1 at 12:03

I see that you are trying to use 20 nested `IF` functions which is not supported in SharePoint.

Check limitation on Microsoft official documentation at: IF function

Workarounds:

So, you have to batch multiple conditions in the bathes of supported limit. Check below links for detailed information and example for this:

``````if(State="AL","Alabama",
if(State="AZ","Arizona",
if(State="AR","Arkansas",
if(State="CA","California",
if(State="CT","Connecticut",
if(State="DE","Delaware",
if(State="FL","Florida",
if(State="GA","Georgia",
if(State="HI","Hawaii",
if(State="ID","Idaho",
if(State="IL","Illinois",
if(State="IN","Indiana",
if(State="IA","Iowa",
if(State="KS","Kansas",
if(State="KY","Kentucky",
if(State="LA","Louisiana",
if(State="ME","Maine",""))))))))))))))))))) &
if(State="MD","Maryland",
if(State="MA","Massachusetts",
if(State="MI","Michigan",
if(State="MN","Minnesota",
if(State="MS","Mississippi",
if(State="MO","Missouri",
if(State="MT","Montana",
if(State="NH","New Hampshire",
if(State="NJ","New Jersey",
if(State="NM","New Mexico",
if(State="NY","New York",
if(State="NC","North Carolina",
if(State="ND","North Dakota",
if(State="OH","Ohio",
if(State="OK","Oklahoma",
if(State="OR","Oregon",
if(State="PA","Pennsylvania",""))))))))))))))))))) &
if(State="RI","Rhode Island",
if(State="SC","South Carolina",
if(State="SD","South Dakota",
if(State="TN","Tennessee",
if(State="TX","Texas",
if(State="UT","Utah",
if(State="VT","Vermont",
if(State="VA","Virginia",
if(State="WA","Washington",
if(State="WV","West Virginia",
if(State="WI","Wisconsin","")))))))))))
``````