+ 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,323

    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 Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,433

    Re: IF formula question (en Français)

    =IF(isna(k2),if(isna(I2),na(),G1),"martini")
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  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
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,454

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  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
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,454

    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. [SOLVED] Newbie Question - Subtraction Formula Question
    By admiral_victory@iol.ie in forum Excel General
    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