ExcelBanter - IF Function returns False instead of 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function returns False instead of 0 (https://www.excelbanter.com/excel-worksheet-functions/31971-if-function-returns-false-instead-0-a.html)

BEEJAY

IF Function returns False instead of 0

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.

Peo Sjoblom

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.

BeeGee

Works like a dream.
Thanks much.

All times are GMT +1. The time now is 05:20 AM.