Forum Discussion
Solved
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 off...
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 did not specify what the output should be if NONE of these cases are TRUE.
I would say an error or blank, but the field should have one of these three scenarios
