Forum Discussion
MikeGG
May 09, 2020Copper Contributor
how many if condition values can i use in one column based on another column?
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
No RepliesBe the first to reply