IF

Hello Tom

Thank you for your question and welcome to the forum.

When using the IF function you can nest the AND or OR function within it so that you can test or evaluate more than one cell.

When ALL criteria need to be met in order for the value_if_true part of the function to be carried out, use AND:
=IF(AND(....),value_if_true,value_if_false).

When ONE of the criteria needs to be met in order for the value_if_true part of the function to be carried out, use OR:
=IF(OR(....),value_if_true,value_if_false)

I hope this helps.

Kind regards
Amanda