Add a select case function
Great news – we’ve introduced the SWITCH function to Office 365 subscribers. If you update today, Aug 19, 2016, (if you haven’t already), you should now have this in your arsenal.
Updating the status here – we’ve actually got something in the works that should be out soon. Stay tuned!
John [MS XL]
The procedure for changing case is too cumbersome for this old dog. Simplify it to match word would make you many points!
Larry Haney commented
I want the formula TEXT "dddd" to be displayed in upper case.
Lindsay Leake commented
I agree with anonymous that change case function in word should be used in excel
The case changing function should be similar to how you do it on Word. The current case changing functions of proper, all caps or all lower case are cumbersome and involve creating additional columns.
Alex B commented
Replace formulas using Nested If functions with much easier to read and more versatile SELECT CASE statement.
Kenneth Barber commented
So Michael, something like SELECTCASE(value, criteria array, return array)?
One advantage of Pat's method is that you can easily incorporate short-circuit evaluation. That is, if you hit your result early, don't evaluate the other results. Not saying that your way can't do this; it'll probably just be harder.
This would be even better if, rather than specifying the criteria in the formula, you could set them in a worksheet. So, for example, in column A you put the minimum number, in column B you put the result, and the formula looks up to that to determine the appropriate result for the case.