Skip to main content

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

 

 

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)

 

Thanks, that was perfect!

Reply


Terms & Conditions