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!!! |
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!!! |
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!!! |
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!!! |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com