Help

Re: Nested IFs only checking first IF

Solved
Jump to Solution
206 0
cancel
Showing results for 
Search instead for 
Did you mean: 
PeteFord
4 - Data Explorer
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
pressGO_design
10 - Mercury
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)

 

See Solution in Thread

2 Replies 2
pressGO_design
10 - Mercury
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)

 

PeteFord
4 - Data Explorer
4 - Data Explorer

Thanks, that was perfect!