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

%3CLINGO-SUB%20id%3D%22lingo-sub-1376772%22%20slang%3D%22es-ES%22%3EHow%20many%20if%20condition%20values%20can%20i%20use%20in%20one%20column%20based%20on%20another%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1376772%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CSPAN%3EGood%20day%2C%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20a%20column%20of%20type%20choice%2C%20I%20have%2021%20options.%20I%20have%20another%20column%20of%20the%20type%20based%20on%20another%20column%20to%20determine%20a%20value%20for%20each%20of%20the%20options%20chosen%20in%20the%20first%20column.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHowever%2C%20when%20using%20the%20IF%20formula%20it%20marked%20me%20with%20a%20syntax%20error%2C%20after%20tests%20I%20verified%20that%20it%20only%20allows%20me%2020%20if%20values%20in%20the%20formula%2C%20when%20more%20it%20marks%20me%20error.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20did%20tests%20with%20my%20formula%20changing%20it%20for%20different%20values%20and%20if%20they%20worked%20for%20me%2C%20the%20error%20is%20when%20including%20more%20than%2020%20values.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAll%20I%20found%20is%20this%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fif-function-7025be14-5665-43d0-af20-8293d1fe9d3a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fif-function-7025be14-5665-43d0-af20-8293d1fe9d3a%3C%2FA%3E%20But%20it%20don't%20specify%20my%20doubt.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECan%20I%20configure%20the%20limit%20of%20IF%20values%3F%20or%20any%20alternative%20that%20they%20suggest%20to%20me.%20It%20will%20be%20of%20great%20help%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1376772%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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