Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Condition formula
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!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Condition formula
Hello, with the formula I got from you,
SI(G4="";SI(G4="no";0;"";NB.JOURS.OUVRES(G4;AUJOUR DHUI())/5)) I get the error message that I am using to manu arguments in my formula, How can I fix this? TK "Bob Phillips" wrote: 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!!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Condition formula
Made a bit of a pigs ear of that one
=SI(G4="";"";SI(G4="non";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 ... Hello, with the formula I got from you, SI(G4="";SI(G4="no";0;"";NB.JOURS.OUVRES(G4;AUJOUR DHUI())/5)) I get the error message that I am using to manu arguments in my formula, How can I fix this? TK "Bob Phillips" wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two condition formula | Excel Worksheet Functions | |||
Add condition to =MAX formula | Excel Discussion (Misc queries) | |||
Condition formula | Excel Discussion (Misc queries) | |||
If formula with two condition | Excel Worksheet Functions | |||
Add condition to formula | Excel Worksheet Functions |