Logical Formulas

Occasional Visitor

I have a large spreadsheet of data that does not divide locations by regions, the if formula allows me to create conditions to associate to a region, but finding it is limited to only 2 if(or()) statements. I have 10 total if conditions, what is the best tool?

1 Reply


You may use nested IF(), up to 256 as I remember, IFS(), perhaps something else. That's better to discuss with a sample.