poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60924] Excel 2016 SWITCH Statement Not Supported
Date Mon, 27 Mar 2017 22:32:23 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

--- Comment #3 from Adrian B. <barnes41@llnl.gov> ---
Created attachment 34878
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34878&action=edit
Example of 2016 SWITCH Statement

According to
https://www.onmsft.com/news/excel-2016-gains-6-new-functions-to-simplify-formula-editing
, there are 6 new formulas.

Here's the Microsoft documentation for each:

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

IFS -
https://support.office.com/en-US/article/IFS-function-36329a26-37b2-467c-972b-4a39bd951d45

CONCAT -
https://support.office.com/en-US/article/CONCAT-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2

TEXTJOIN -
https://support.office.com/en-US/article/TEXTJOIN-function-357b449a-ec91-49d0-80c3-0e8fc845691c

MAXIFS -
https://support.office.com/en-us/article/MAXIFS-function-dfd611e6-da2c-488a-919b-9b6376b28883

MINIFS -
https://support.office.com/en-us/article/MINIFS-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message