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