Generic selectors
Exact matches only
Search in title
Search in content

Reply To: Excel IFS()

Barry Fish

Thanks for that. I agree it’s a function that makes life easier, but I don’t like the way they handled the default catch all option. You have to use the final pair of arguments. By setting the penultimate argument to “true”, the final argument is always returned if no other tests passed.

It’s logical but feels clumsy. Why don’t they check whether there are an even or odd number of parameters. If it’s odd, then use the final argument as the catch-all with no unnecessary final test. In fact, this would also make it a direct replacement for IF with only one test covered with three arguments. You could add further tests and results by adding arguments 3 and 4, then 5 and 6 etc.