Access User Defined Function in all workbooks in Excel.
How to create User Defined functions to speed up you work. Use these functions for commonly use calculations on your worksheets. I will tell you how to reference these functions to that they can be use on every worksheet that you create.
The Code for the Functions that I use
Public Function profit(saleprice As Integer, cost As Integer) As Integer
profit = saleprice – (cost * 1.07)
End Function
Public Function datedue(purchase As Date) As Date
datedue = purchase + 30
End Function
For more help visit my website or email me at [email protected].
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
Follow me on Facebook
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
