If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.

How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what ...

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 ...