ExcelCustomFunctions

中文

Customize Excel functions with Microsoft Advanced Formula Environment

---

Preparation

Functions based on LAMBDA functions, to get access to LAMBDA functions, please make sure you have updated to the latest version of Excel. Specifically versions greater than or equal to:

• Windows: 16.0.14729.20260
• Mac: 16.56 (Build 21121100)
• iOS: 2.56 (Build 21120700)
• Android: 16.0.14729.20176

Install the new add-in named "Advanced formula environment, a Microsoft Garage project", which allows easy import/export and authoring of named LAMBDAs.

More description can be found via:

• Announcing LAMBDAs to Production and Advanced Formula Environment, A Microsoft Garage Project
• Big News！这个函数正式发布了，远远超出期待-LAMBDA

Use the functions

Just import the txt file to use the customize functions easily.

Choose a function list from the project, input the list to the Advanced Formula Environment add-in and use it. You can download the txt file or just copy the link below.

• Statistics functions：./statistics
• Finance functions：./finance
• Accounting functions：./accounting
• Datetime functions：./datetime

Improve the project by sharing your function

If you want to share your functions or idea, we are happy to receive your PR, and we will make consideration of your requirement raised via issue.

Function submission specification

• Custom functions should contain comments that specify the function name, function description, parameters and parameter definitions, examples, and the function ontology
• Generic function names should be in Uppercase English, consistent with Excel's native function style. Specific function should be named humps to describe function functions concisely and accurately
• Arguments naming should be in lowercase letters, and multiple words are seprate by underline, consistent with excel's native function parameter style. Arguments should indicate the meaning of itself and the special requirements for the type
• Examples should be concise, clear, and comprehensively cover the functionality of the function
• Function ontology should be concise and accurate, avoiding meaningless code

Example:

/*

FUNCTION NAME: IFBLANK

DESCRIPTION: Checks if a value is blank and returns value_if_blank if it is

ARGS:

value: The value to check if it's blank

value_if_blank: The value to return if a blank value is found

EXAMPLE:

=IFBLANK(,"blankVal")

*/

IFBLANK =LAMBDA(value, value_if_blank, IF(ISBLANK(value),value_if_blank,value));

Idea submission specification

To be finished

Requirement submission specification

To be finished