## General Question

# Combining many IF statements in excel?

Asked by jedwards1000 (4)
1 week ago

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

## 2 Answers

## Answer this question

This question is in the General Section. Responses must be helpful and on-topic.

Have a question?
Ask Fluther!