+ Reply to Thread
Results 1 to 7 of 7

IF formula question (en Français)

  1. #1
    Registered User
    Join Date
    04-06-2020
    Location
    London
    MS-Off Ver
    2002
    Posts
    4

    Lightbulb IF formula question (en Français)

    Bonjour!!

    J'ai une question, je cherche a faire un If (je suis sur une version UK) avec 2 colonnes:

    Martini G1
    12 #N/A
    #N/A 13

    J'ai lexample suivant avec 2 colonnes: Martini et G1.
    Je cherche a faire un if pour:
    - Si la valeur dans martini est different de #N/A, alors la valeur est martini
    - Si la valeur dans G1 est different de #N/A, alors la valeur est G1
    - Si on a #N/A dans chaque, alors #N/A

    Note: Il ne peut pas avoir une valeur autre que #N/A dans Martini at G1.

    J'ai cree la formule suivante mais elle ne marche pas:

    =IF(K2<>"#N/A","Martini",IF(K2="#N/A" & L2<>"#N/A","G1","#N/A")

    K etant la colonne pour Martini, L pour G1.
    La formule marche pour Martini mais pas pour G1.

    Merci,
    Last edited by tofoo; 06-09-2020 at 07:59 AM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: IF formula question (en Français)

    Peut-être

    =IF(and(isna(k2),isna(l2)),na(),if(not(isna(k2),"martini","G1")))



    Utiliser une référence de cellule comme G1 comme titre n'est pas vraiment une bonne idéée et pourrait porter à confusion..
    Last edited by arthurbr; 06-10-2020 at 02:04 AM.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: IF formula question (en Français)

    =IF(isna(k2),if(isna(I2),na(),G1),"martini")
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  4. #4
    Registered User
    Join Date
    04-06-2020
    Location
    London
    MS-Off Ver
    2002
    Posts
    4

    Re: IF formula question (en Français)

    Hello!

    Merci pour vos reponses, j ai essaye les 2 solutions mais celle propose par Arthur me donne un message d erreur: Too many argument for this function.
    Je ne suis pas sur de ce que ca veux dire.

    J ai ensuite essaye celle de Mehmet, ca marche pour affichier Martini mais pas G1. J ai mis un example en piece jointe.
    Attached Files Attached Files

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,400

    Re: IF formula question (en Français)

    Peut-être:

    =IF(and(isna(k2),isna(l2)),na(),if(not(isna(k2)),"martini","G1"))

    J’ai modifié les parenthèses.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    04-06-2020
    Location
    London
    MS-Off Ver
    2002
    Posts
    4

    Re: IF formula question (en Français)

    Bien vu ALi ! Ca marche maintenant!!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,400

    Re: IF formula question (en Français)

    Super! Je vous en prie.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel project in finance (français)
    By corneille72 in forum Non English Excel
    Replies: 2
    Last Post: 06-03-2015, 09:06 AM
  2. Replies: 1
    Last Post: 03-04-2012, 12:03 AM
  3. Ctrl-D en francais
    By Sibrulotte in forum Non English Excel
    Replies: 2
    Last Post: 02-21-2012, 05:22 PM
  4. Replies: 2
    Last Post: 10-08-2009, 09:51 PM
  5. [SOLVED] Formula question-change formula based cell calling it?
    By seethesun in forum Excel General
    Replies: 2
    Last Post: 02-08-2009, 01:39 PM
  6. Replies: 3
    Last Post: 05-05-2006, 12:55 PM
  7. IF formula question:edit the fist half of the original formula
    By impress in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 08:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1