how many if condition values ​​can i use in one column based on another column?

New Contributor

Good day,

In a column of type choice, I have 21 options. I have another column of the type based on another column to determine a value for each of the options chosen in the first column.

However, when using the IF formula it marked me with a syntax error, after tests I verified that it only allows me 20 if values ​​in the formula, when putting more it marks me error.

I did tests with my formula changing it for different values ​​and if they worked for me, the error is when including more than 20 values.

All I found is this: https://support.microsoft.com/en-us/office/if-function-7025be14-5665-43d0-af20-8293d1fe9d3a But it dont specify my doubt.

 

Can I configure the limit of IF values? or any alternative that they suggest to me. It will be of great help

0 Replies