How can I modify this SWITCH statement to show "Below Investment Grade, Highly Speculative" for any data entered like this:
basically a numerical modifier at the end.
I dont think I can use
[MoodyRating] like "B*" because I a user could enter only a Baa or Ba.
I have not copied the entire switch statement but only a bit of it:
=Switch([MoodyRating]="Baa","Investment Grade, but lower end",
[MoodyRating]="Ba1","Speculative, substantial Credit Risk",
[MoodyRating] = "B1", "Below Investment Grade, Highly Speculative")
Hope that makes sense.