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.

elbanditoroso (33577points)“Great Answer” (0points) Flag as…
RocketGuy's avatar

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

RocketGuy (15550points)“Great Answer” (4points) Flag as…

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