Nested IF Statements

[QBERT]

Here is my equation:

=IF((M5="","",IF((NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17))<1),"1",IF((NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17))>=1),(NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17),"False")))


What I am trying to do is as follows:

- If Cell M5 is Blank, display "Blank" its an empty cell

- If not I want it to calculate the network days.intl and display a value of 1 for any returned value less than 1

- Then if it is not less than 1 and equal to or greater than 1 I want it to display the actual value.


My syntax is flawed somewhere and I cannot figure it out. Any help is appreciated.

 

[Dave Patton]

=IF(M5="","",NETWORKDAYS.INTL(X5,M5,11,$O$4:$O$17))

N.B. Edit the range for Holidays.

 

[Dave Patton]

=if(m5="","",networkdays.intl(x5,m5,11,$o$4:$o$17))

n.b.

 

[Peter_SSs]

try

=IF(M5="","",MAX(NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17),1))

 

[QBERT]

try

=IF(M5="","",MAX(NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17),1))

Works great! Thanks for the help!

Q

 

[Peter_SSs]

Works great! Thanks for the help!

Q

You are welcome. Thanks for the follow-up.

 

[QBERT]

Your welcome and I just posted another question on one more Nested If equation I am trying to write.