Feedback by UserVoice

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

Kill nested IFs

What about a function like =ELSEIF([if1]; [then1]; [elseif2]; [then2]; [elseif3]; [then3]; ...)

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Give our new IFS and SWITCH functions a go – they are exactly what you’re looking for.

    Cheers,
    Dan [MS]

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        Yes, but only if you have Office 365. Will it be available for Office Desktop Pro?

      • Mal commented  ·   ·  Flag as inappropriate

        Oh, you're already done. Great, thanks! Now how do I convince IT to roll out Office 2016? We just got 2013. ;-)

      Feedback and Knowledge Base