Multiple =IF Function

ProTee 

Welcome, to one retiree from another.

First, I admire your enthusiasm and your desire to learn. It's hard, though, I must tell you, even though you've done a yeoman's job of describing the situation and provided a helpful image....a copy of your actual spreadsheet would give us here (including those youngsters who've not yet retired, but may have a better handle on Excel than either you or I)...a bit more to work with than the image file alone.

I did notice the elaborate IF function you'd written in that image....have you tried IFS? It is a bit easier to work with multiple conditions in IFS, provided you have them in the right sequence (and I think the sequence you've got in your verbal description should work). Here's a link to a website that you might appreciate in general (great tutorials on all the different functions), but here I've taken you directly to the description of IFS and how to use it. https://exceljet.net/excel-functions/excel-ifs-function