Forum Discussion
LizA2020
Jan 22, 2025Copper Contributor
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))
- NnyiimockBitanyanmiBrass Contributor
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))
- LizA2020Copper Contributor
Thank you !!!!
- Detlef_LewinSilver Contributor
You did not specify what the output should be if NONE of these cases are TRUE.
- LizA2020Copper Contributor
I would say an error or blank, but the field should have one of these three scenarios