Build 4.0.0.43 of xlsgen continues and finishes what was begun with the earlier build, by adding the 4 last functions (out of 6) newly introduced by Microsoft in their Office 365 offerings as well as the online version of Excel, namely :
- IFS(expression1, result_if_true_1 [, expression2, result_if_true_2, ...]) : combine multiple conditions in a single statement. This function is useful for avoiding IF() nesting. The official documentation is
here.
- SWITCH(expression, value1, result1, [,value2, result2, ...] [default value]) : switch statement for selecting a discrete value out of n values. Optional use of a default value (last parameter). The official documentation is
here.
- MAXIFS(range, range1, expression1, [, range2, expression2]) : combine multiple conditions for calculating a max value. The official documentation is
here.
- MINIFS(range, range1, expression1, [, range2, expression2]) : combine multiple conditions for calculating a min value. The official documentation is
here.
Complete with TEXTJOIN() and CONCAT(), these are the 6 new functions that xlsgen makes available to all Excel users, not just a fraction like Microsoft would like to do.