View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Condition formula

SI(G4="";SI(G4="no";0;"";NB.JOURS.OUVRES(G4;AUJOUR DHUI())/5))


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pascale" wrote in message
...
To this formula, SI(G4="";"";NB.JOURS.OUVRES(G4;AUJOURDHUI())/5)
I want to add the condition if the answer is no, please enter 0 in the
case.


Thank you so much for your help!!!