Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, May 19, 2009 – Permalink –

UDF is not a Baby Alien

Things should to function


Frank Rice has written a "show how" about creating functions that are not included in the box.


"Excel allows you to create custom functions, called "User Defined Functions" (UDF's) that can be used the same way you would use SUM(), VLOOKUP, or other built-in Excel functions.
The Excel user who wishes to use advanced mathematics or perform text manipulation is often seriously disappointed by Excel's limited library of formulas and functions. A UDF is simply a function that you create yourself with VBA.

The following is a sample that is a good candidate for a UDF:
Function CtoF(Centigrade)
CtoF = Centigrade * 9 / 5 + 32
End Function

In the Worksheet you would enter something like:
=CtoF(A1)


frice's Weblog

Here are some other links:

Vertex42.com:
User Defined Functions


Support.Microsoft.com:
Functions to Calculate Light Years



[Edited entry from 3/27/2006]




See all Topics

Labels:


<Doug Klippert@ 3:38 AM

Comments: Post a Comment

Links to this post:

Create a Link