Jan 14 2022 03:52 AM
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?
Jan 14 2022 08:14 AM
You may use nested IF(), up to 256 as I remember, IFS(), perhaps something else. That's better to discuss with a sample.