Combining many IF statements in excel?
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”))
Topics:
Observing members:
0
Composing members: 0
Composing members: 0
Answers
elbanditoroso
(33160
)“Great Answer”
(0)
)“Great Answer”
(0)
RocketGuy
(15239)“Great Answer”
(4)
)“Great Answer”
(4)
