Nested IFs only checking first IF

[PeteFord]

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()
          )
        )
    )
)

[pressGO_design · Accepted solution]

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]

Thanks, that was perfect!