General Question

jedwards1000's avatar

Combining many IF statements in excel?

Asked by jedwards1000 (4points) July 10th, 2018

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

elbanditoroso's avatar

Try this? link

I did a search on Google – “combined IF Excel” and there were oodles of results.

RocketGuy's avatar

You have an extra ”=” in the middle, which is screwing up the equation.

Answer this question

Login

or

Join

to answer.

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

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther