Forum Discussion

17 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 18, 2019

    Sabeel 

    As a comment - Twifoo formulas works, as Detlef_Lewin says you only shall change curve quote on straight quote. That could be misprint, but one to another is often changed when you copy/paste from Web or back.

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Dec 18, 2019

    Sabeel

     

    Hi,

     

    Try one of these formulas:

    =IF(OR(ISNUMBER(MATCH(F3,$A$3:$A$9,0)),
    ISNUMBER(MATCH(G3,$B$3:$B$9,0)),
    ISNUMBER(MATCH(H3,$C$3:$C$9,0))),"done","")

     

    =IF(SUMPRODUCT(--(F3:H3=$A$3:$C$9)),"done","")

     

     

    Hope that helps

    • Sabeel's avatar
      Sabeel
      Copper Contributor
      Dec 19, 2019
      Thanks For Replay , its worked
  • NobukoIT's avatar
    NobukoIT
    Copper Contributor
    Dec 18, 2019

    Sabeel 

    What about this method?

    H9=IF(COUNTIFS($A$7:$C$13,$E9)+COUNTIFS($A$7:$C$13,$F9)+COUNTIFS($A$7:$C$13,$G9)>0,"done","not done")
    H10=IF(COUNTIFS($A$7:$C$13,$E10)+COUNTIFS($A$7:$C$13,$F10)+COUNTIFS($A$7:$C$13,$G10)>0,"done","not done")
    H11=IF(COUNTIFS($A$7:$C$13,$E11)+COUNTIFS($A$7:$C$13,$F11)+COUNTIFS($A$7:$C$13,$G11)>0,"done","not done")
    H12=IF(COUNTIFS($A$7:$C$13,$E12)+COUNTIFS($A$7:$C$13,$F12)+COUNTIFS($A$7:$C$13,$G12)>0,"done","not done")

     

     

     
  • alenezi's avatar
    alenezi
    MCT
    Dec 18, 2019

    Hello, us =IF(logical_test,value_if_true,value_if_false)

     

    Logical_test: is any value or expression that can be evaluated to TRUE or FALSE.

     

    Value_if_true: is the value that is returned if Logical_test is TRUE. If omitted, TRUE is returned. You can nest up to seven IF functions.

     

    Value_if_false: is the value that is returned if Logical_test is FALSE. If omitted, FALSE is returned.

Resources