View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
stacy[_2_] stacy[_2_] is offline
external usenet poster
 
Posts: 30
Default Multi-Conditional IF Statements

Okay... I think I have figured out my own question... I use the
following formula and it works just fine:

=IF(AND(F6="",E6<D6),NETWORKDAYS(E6,D6,M$6:M$14)-1,IF(AND(F6="",E6D6),NETWORKDAYS(E6,D6,M$6:M$14)+ 1,IF(AND(F6="",E6=D6),"0",IF(F6<"",NETWORKDAYS(F6 ,D6,M$6:M$14)+1,0))))

However, if anyone has something a little more direct or simple, I am
always open to learning new approaches! Thanks for your time...