How to not include blank cells in an IF function

[Tim93M]

Hi all,

I'm stuck and I hope you can help.
If have very simple =IF function, =IF(F4=H4;1;0) but don't wan't the 'value is true' value when both cells are empty, how do I need to change the function so it states 0?

[Richard Buttrey]

Hi, and welcome to the forum,

One way (probably of several)

Please Login or Register  to view this content.

[ben_hensel]

Nest an AND inside there to check for two outcomes.

Please Login or Register  to view this content.

BTW it looks like you can just return a boolean response, so you could actually drop the IF entirely and just do the logic.

Please Login or Register  to view this content.

Like that.

[Tim93M]

Thank you! It works like a charm.
(Also thanks for the quick response)