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 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.
