General Question
![jedwards1000's avatar](http://dkg88rp4qbe6q.cloudfront.net/avatars/bjelly4_thumb.jpg)
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”))
Observing members:
0
Composing members:
0
![](http://d3phpakcjc7x1x.cloudfront.net/images/v2/eye.png)
![](http://d3phpakcjc7x1x.cloudfront.net/images/v2/pencil.png)
2 Answers
Answer this question
This question is in the General Section. Responses must be helpful and on-topic.
Have a question?
Ask Fluther!