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: 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