Notifications
Mark all as read
Q&A

What formula would fetch the content of Cell B12 unless either that is blank or a space, in which case `0` should be returned instead?

+0
−1

For Excel 2013.

Based on this Identifying a blank cell in Excel Office 365 using the function =IF(ISBLANK) as yet unanswered from @robert on Stack Overflow, a long time ago, where the context was "excel office 365 for Mac".

Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

1 comment

@pnuts There is something unclear in the post. It mentions both Excel 2013 and Office 365 (for MAC). What is the actual application? Alexei‭ 29 days ago

1 answer

+0
−0

This:

=IF((B12=" ")+(B12=""),0,B12)

will return 0 when B12 is blank or a space and otherwise the value in B12.

IF

Why does this post require moderator attention?
You might want to add some details to your flag.

0 comments

Sign up to answer this question »