Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Add a select case function

=Selectcase(A1>89,"A",A1>79,"B",>69,"C",A1>"59,"D","F")

7 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

pat shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  Dan Battagin [MS XL] responded  · 

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.

https://support.office.com/en-us/article/SWITCH-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e

Cheers,
Dan [MS]

Updating the status here – we’ve actually got something in the works that should be out soon. Stay tuned!

Best,
John [MS XL]

5 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Replace formulas using Nested If functions with much easier to read and more versatile SELECT CASE statement.

  • Kenneth Barber commented  ·   ·  Flag as inappropriate

    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.

  • Michael commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base