For more complex scenarios, Excel also offers the IFS function, which allows multiple conditions to be tested in a single formula without nesting/complicated syntax. IFS statements are written ...

I was thinking a built VB function, only becuase I can wrap my head around the problem a lot more easily via programming than I can around what I think Excel has built in. What I don't have, is ...