Combining equations

mpajuelo

How do I combine IF/AND/OR equation. I would like to condense my IF/AND equations. I have 2 sets of equations that produce the same output the only change is the "Talent" column can either be "External" or "Rescue". Here is my equation that currently works:

Paul Newcome

It would look somethign like

=IF(AND(OR(Talent@row = "External", Talent@row = "Rescue"), Time@row = "Half"), ................

Paul Newcome

It would look somethign like

=IF(AND(OR(Talent@row = "External", Talent@row = "Rescue"), Time@row = "Half"), ................

mpajuelo

Thank you!

Paul Newcome

Happy to help. 👍️