Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel Miscellaneous » Non English Excel » Question de IF avec plusieurs statements

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 08-19-2008, 08:29 AM
feejo feejo is offline
Forum Contributor
  
Join Date: 18 May 2007
Posts: 148
feejo is becoming part of the community
Question de IF avec plusieurs statements

Please Register to Remove these Ads

Question de IF avec plusieurs statements
if a1>0 et a2>0 résultat oui="oui"
si non "non"

merci
__________________
Running excel 2007 SP1 Have a nice day.
Reply With Quote
  #2  
Old 08-19-2008, 09:14 AM
daddylonglegs's Avatar
daddylonglegs daddylonglegs is offline
Forum Moderator
  
Join Date: 14 Jan 2006
Location: England
MS Office Version:2002 (work), 2003 & 2007 (home)
Posts: 6,565
daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding
Peut-etre

=IF(AND(A1>0,A2>0),"oui","non")
Reply With Quote
  #3  
Old 08-19-2008, 01:17 PM
shg's Avatar
shg shg is offline
Forum Guru
  
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,528
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
Tres bien, DLL!
Last edited by shg; 08-19-2008 at 03:47 PM.
Reply With Quote
  #4  
Old 08-20-2008, 02:25 AM
arthurbr's Avatar
arthurbr arthurbr is offline
Non English Excel Moderator
  
Join Date: 23 Dec 2006
Location: Belgium
MS Office Version:XL2003
Posts: 2,890
arthurbr has an addiction to Excel
Et sauf erreur de ma part, en version française la fonction IF se nomme SI

Quote:
Peut-etre

=IF(AND(A1>0,A2>0),"oui","non")
Ddll you are a man of many talents !
__________________

If you are pleased with a member's answer then use the Scales icon to rate it
Reply With Quote


Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Case Select statements with "if" statements compulsiveguile Excel Programming 2 08-12-2008 12:05 PM
More than 7 IF statements NoiCe Excel General 4 01-19-2008 04:51 PM
Conditional locking of a cell?? KevinCromley Excel Programming 0 11-11-2007 05:23 PM
Coding CountIf Statements cmcconnehey Excel Programming 2 04-25-2007 10:46 AM
macro question and count question... thanks! bstaff Excel General 5 02-07-2007 09:12 AM

Contact Us - ExcelTip.com - Archive - Top