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
(thinking…)
Sign in with: facebook google
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
(thinking…)
Sign in with: facebook google
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