Custom Functions in Excel
โดย Better Solutions Limited
This add-in provides additional worksheet functions that will increase your productivity
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
ความสามารถของแอป
- สามารถอ่านและเปลี่ยนแปลงเอกสารของคุณได้
- สามารถส่งข้อมูลผ่านทางอินเทอร์เน็ต