IF Function returns False instead of 0

One way

=IF(C6<>E11,0,IF(C5<>D11,0,IF(C3<=28,F11,0)))

Regards,

Peo Sjoblom

"BEEJAY" wrote:

> I must be going blind.
>
> The first statement returns a "false" when not equal
> Likewise the second.
> The third returns a zero (0).
> I need a Zero from each one (if applicable), instead of "false".
> What am I overlooking.
> I'm thought I've used this satisfactorily before, but I'm stuck now.
>
> =IF(C6=E11,IF(C5=D11,IF(C3<=28,F11,0)))
>
> Thanks in advance.

Works like a dream.
Thanks much.

I must be going blind.

The first statement returns a "false" when not equal
Likewise the second.
The third returns a zero (0).
I need a Zero from each one (if applicable), instead of "false".
What am I overlooking.
I'm thought I've used this satisfactorily before, but I'm stuck now.

=IF(C6=E11,IF(C5=D11,IF(C3<=28,F11,0)))

Thanks in advance.

One way

=IF(C6<>E11,0,IF(C5<>D11,0,IF(C3<=28,F11,0)))

Regards,

Peo Sjoblom

"BEEJAY" wrote:

> I must be going blind.
>
> The first statement returns a "false" when not equal
> Likewise the second.
> The third returns a zero (0).
> I need a Zero from each one (if applicable), instead of "false".
> What am I overlooking.
> I'm thought I've used this satisfactorily before, but I'm stuck now.
>
> =IF(C6=E11,IF(C5=D11,IF(C3<=28,F11,0)))
>
> Thanks in advance.

Works like a dream.
Thanks much.