Custom Functions in Excel

If you are familiar with VBA user defined functions, then this add-in is definitely for you.

This add-in provides additional worksheet functions that you can use in your regular formulas to help perform data analysis and data manipulation.

Our list of initial functions has been taken from the following add-ins: ASAP Utilities, Power Utility Pack, KuTools, OzGrid and MoreFunc.

We are slowly adding to this list, so please let us know if there are any functions you would like us to include.

Important

You must have an Office 365 subscription.

Your version of Office 365 must be at least 16.0.11629 on Windows 10.

This add-in will work on the Desktop and Office Online.

Features

Over 50 additional worksheet functions

Add sample data quickly for faster learning

Replace all the functions with formulas or values

Every function is documented with examples on our website

Popular Functions

COUNTFORMAT

NUMBEROFDAYS

SPELLNUMBER

SUMFORMAT

Examples

SpellNumber(23) = "Twenty Three"

SpellNumber(4681) = "Four Thousand, Six Hundred and Eighty One"

Support

This add-in will not work on Office 2016, Office 2019 or Office 2021.

This add-in will not work with Windows 7.

This add-in will not work with Internet Explorer 11.

To get the latest builds, you will need to be on the Monthly Channel.

Documentation

https://bettersolutions.com/addins/excel-custom-functions