True / False

[Frank Bacchus]

Hi All:

I have the following formula and would like to change the output when it is "False" to 0. See below:

Formula: =IF(E5="PARKED",NETWORKDAYS($D$5,VALUE(TODAY())))

Cell (D5) Open or Parked (E5) Results
05/09/2016 Open FALSE

Cell (D5) Open or Parked (E5) Results
05/09/2016 PARKED 47

Would like to see:

Cell (D5) Open or Parked (E5) Results
05/09/2016 Open 0

Cell (D5) Open or Parked (E5) Results
05/09/2016 PARKED 47

Thanks in Advance

frank

 

[Chihiro]

Just add argument/operation for false. =IF(logical check, True, False)

=IF(E5="PARKED",NETWORKDAYS($D$5,VALUE(TODAY())),0)

 

[Shteven]

You could also use a double unary operator:

=--IF(E5="PARKED",NETWORKDAYS($D$5,VALUE(TODAY())))

 

[bosco_yip]

Another option..........

=(E5="PARKED")*NETWORKDAYS($D$5,VALUE(TODAY()))

Since,

(E5="PARKED") return 1 or, 0

NETWORKDAYS($D$5,VALUE(TODAY())) return 47

Therefore,

=(E5="PARKED")*NETWORKDAYS($D$5,VALUE(TODAY()))

=1*47

=47

Or....,

=0*47

=0

Regards

 

[bosco_yip]

Another option..........

=(E5="PARKED")*NETWORKDAYS($D$5,VALUE(TODAY()))

Since,

(E5="PARKED") return 1 or, 0

NETWORKDAYS($D$5,VALUE(TODAY())) return 47

Therefore,

=(E5="PARKED")*NETWORKDAYS($D$5,VALUE(TODAY()))

=1*47

=47

Or....,

=0*47

=0

Regards

I see some typo, should read as…….

Since,

(E5="PARKED") return TRUE or, FALSE

NETWORKDAYS($D$5,VALUE(TODAY())) return 47

Therefore,

=(E5="PARKED")*NETWORKDAYS($D$5,VALUE(TODAY()))

=TRUE*47

=47

Or....,

=FALSE*47

=0

Regards