- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 22, 2024 08:56 AM
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()
)
)
)
)
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 22, 2024 01:45 PM
I'm assuming that
- only one of these things is filled, and
- you want to know what that one thing is, and
- 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)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 22, 2024 01:45 PM
I'm assuming that
- only one of these things is filled, and
- you want to know what that one thing is, and
- 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)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 25, 2024 03:22 AM
Thanks, that was perfect!
