# Two IF formulas work apart but not together đź’”

I need some Airtable Formula help. I am trying to merge the below. Iâ€™ve been looking at it so long I canâ€™t work out what is going on any more!

This works:

IF({Rejected}, IF({Rejection Reason}=â€śUnresponsiveâ€ť,â€śUnresponsiveâ€ť,
IF({Rejected}, IF({Rejection Reason}!=â€śUnresponsiveâ€ť,â€śRejectedâ€ť))))

And this does too:

IF(Rejected}=BLANK(),IF({Status 1}+{Status 2}=2,â€śDoneâ€ť,
IF(Rejected}=BLANK(),IF({Status 1}+{Status 2}=1,â€śOne of twoâ€ť,
IF(Rejected}=BLANK(),IF({Status 1}+{Status 2}=0,â€śPendingâ€ť
))))))

However, if I put them together, then it only displays the results of the first 2 lines.

If I switch it around so the 3 lines goes first, then it only displays the results of the 3 lines.

Not sure why but any help gratefully received.

Try this:

`IF({Rejected}, IF({Rejection Reason}="Unresponsive", "Unresponsive", "Rejected"), IF({Rejected=BLANK(), SWITCH({Status 1}+{Status 2}, 2, "Done", 1, "One of Two", "Pending")))`

Fantastic! That works perfectly. Thank you so much.

Any idea why the way I tried didnâ€™t work?

If I had to guess, Iâ€™d say it was something to do with how you combined the formulas, likely improper nesting. Simplifying redundant IF() statements usually makes it easier to see where the different pieces of a complicated formula go.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.