I am trying to use a formula in excel to check a specific cell in identical tabs and give either a blank result or insert the word “RELAY” on another tab. I can only get the formula to singularly How can I combine the following formula to work in this way.
=IF(A1=Assets!B78,IF(JANUARY!E6=””,””,“RELAY”))

Ideally, if I could combine the two simply, I would do this, but it doesn’t work.

=IF(A1=Assets!B78,IF(JANUARY!E6=””,””,“RELAY”,=IF(A1=Assets!B78,IF(FEBRUARY!E6=””,””,“RELAY”))