Forum Discussion

LizA2020's avatar
LizA2020
Copper Contributor
Jan 22, 2025

Formula assistance please

I am trying to bring back a value when choosing between a variety of selections. =IF(G2="SLP Therapy",0.5,IF(G2="SLP Eval",1,IF(G2="Lien",1))).   The end result is coming up as FALSE.  Can anyone offer guidance?

  • To return a blank if none of the conditions is true:

    =IF(G2="SLP Therapy",0.5,IF(OR(G2={"SLP Eval","Lien"}),1,""))

    To return a specific text:

    =IF(G2="SLP Therapy",0.5,IF(OR(G2={"SLP Eval","Lien"}),1,"Specific Text"))

    To return 0:

    =IF(G2="SLP Therapy",0.5,IF(OR(G2={"SLP Eval","Lien"}),1,0))

  • You always need to provide what should happen if all your options does not work. Apart from that you could also use IFERROR to handle unforseen hitches.

  • To return a blank if none of the conditions is true:

    =IF(G2="SLP Therapy",0.5,IF(OR(G2={"SLP Eval","Lien"}),1,""))

    To return a specific text:

    =IF(G2="SLP Therapy",0.5,IF(OR(G2={"SLP Eval","Lien"}),1,"Specific Text"))

    To return 0:

    =IF(G2="SLP Therapy",0.5,IF(OR(G2={"SLP Eval","Lien"}),1,0))

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    You did not specify what the output should be if NONE of these cases are TRUE.

     

    • LizA2020's avatar
      LizA2020
      Copper Contributor

      I would say an error or blank, but the field should have one of these three scenarios

Resources