On Friday, July 8, 2016 at 10:47:48 AM UTC-4, Claus Busch wrote:
Hi Garry,

Am Fri, 08 Jul 2016 09:22:59 -0400 schrieb GS:

Wizard!!!

I don't like nested IF formulas. Easily you lose track of things.
With the latest update of Excel 2016 there is the function IFS where you
can insert 127 arguments. What a nonsense.


Regards
Claus B.
--
Windows10
Office 2016

127?!? Agreed. Too convoluted. I need to learn how to use the Index and Match functions. It appears much more straightforward... but I will have to do some studying. Right now I only know that it works, not how.
Many thanks, Paul