# Re: Nested IFs only checking first IF

Solved
206 0
cancel
Showing results for
Did you mean:
4 - Data Explorer

hi there,

I am trying to create a nested IF that checks if four cells are blank, and if they're not, returns the value that's there.

When I use the below formula, it only ever checks the first IF, and it's driving me nuts!

Can anyone help? I want it to return BLANK if there are no matches.

``````IF(
ArtSaleChecker2!=BLANK(),
ArtSaleChecker2,
IF(
PromSaleChecker2!=BLANK(),
PromSaleChecker2,
IF(OtherSaleChecker2!=BLANK(),
OtherSaleChecker2,
IF(GenSaleChecker2!=BLANK(),
GenSaleChecker2,
BLANK()
)
)
)
)``````

1 Solution

Accepted Solutions
10 - Mercury

I'm assuming that

1. only one of these things is filled, and
2. you want to know what that one thing is, and
3. if nothing is filled you want it to be blank.

If that's the case, then

IF(ArtSaleChecker2, ArtSaleChecker2)&
IF(PromSaleChecker2, PromSaleChecker2)&
IF(OtherSaleChecker2, OtherSaleChecker)&
IF(GenSaleChecker2, GenSaleChecker2)

2 Replies 2
10 - Mercury

I'm assuming that

1. only one of these things is filled, and
2. you want to know what that one thing is, and
3. if nothing is filled you want it to be blank.

If that's the case, then

IF(ArtSaleChecker2, ArtSaleChecker2)&
IF(PromSaleChecker2, PromSaleChecker2)&
IF(OtherSaleChecker2, OtherSaleChecker)&
IF(GenSaleChecker2, GenSaleChecker2)

4 - Data Explorer

Thanks, that was perfect!