Hi @Philip442
This link might be helpful for you, please check there are some examples as well
IFS function - Office Support (microsoft.com)
If this doesn't resolve your issue, feel free to post your query in detail with sample data of bonus criteria to advise you appropriate solution.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
