Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions User Defined< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

Step By Step

 -

Using Functions

Step By Step

 -

Writing Functions

Step By Step

 -

Function Categories

Step By Step

 -

Function Descriptions

Step By Step

 -

Function Arguments

Step By Step

 -

Return Errors

Step By Step

 -

Recalculating Functions


 

User Defined Functions

 
GoTo

 -

ACRONYM - Returns the first letter of each word.

GoTo

 -

AGE - Returns the age of a person given a birthday.

GoTo

 -

AVERAGEIF - Returns the average of a range of values that match a certain condition.

GoTo

 -

COLOURCOUNT - Returns the number of cells that contain a particular colour.

GoTo

 -

COLOURINDEX - Returns the colour index for a particular cell.

GoTo

 -

COLUMNWIDTH - Returns the column width of the active cell.

GoTo

 -

COMMENTTEXT - Returns the comment associated with a particular cell.

GoTo

 -

CONTAINS - Returns whether a string is contained within another string.

GoTo

 -

COUNTFORMAT - Returns the number of cells that have a particular format.

GoTo

 -

FINDMATCH - Returns the position of an item in a list.

GoTo

 -

FORMULAGET - Returns the formula from a particular cell.

GoTo

 -

ISFORMULA - Returns whether a particular cell contains a formula.

GoTo

 -

ISLIKE - Returns whether a particular string matches a certain pattern.

GoTo

 -

MAXIF - Returns the maximum value in a range of values that match a certain condition.

GoTo

 -

MEDIANIF - Returns the median value in a range of values that match a certain condition.

GoTo

 -

MINIF - Returns the minimum value in a range of values that match a certain condition.

GoTo

 -

NETWORKDAYSMISC - Returns the number of days between two dates using a defined list of workdays.

GoTo

 -

NUMBERFORMATGET - Returns the number format used on a particular cell.

GoTo

 -

PERCENTARE - Returns the percentage of numbers in a range that meet a particular condition.

GoTo

 -

REVERSE - Returns the cell contents with all the characters reversed.

GoTo

 -

ROWHEIGHT - Returns the row height of the active cell.

GoTo

 -

SCRAMBLE - Returns the cell contents with all the characters in a random order.

GoTo

 -

SHEETCOUNT - Returns the total number of sheets in the active workbook.

GoTo

 -

SHEETNAME - Returns the name of a worksheet in the active workbook given an index position.

GoTo

 -

SPELLNUMBER - Returns the word equivalent for a numerical number.

GoTo

 -

WORKBOOKNAME - Returns the name of the active workbook.

GoTo

 -

WORKDAY6 - Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.

GoTo

 -

WORKDAYSMISC - Returns the serial number before or after a given number of days from a start date using a defined list of workdays.


 

Advanced

 
More Details

 -

Office Online

More Details

 -

Knowledge Base


 

Related Topics

 
GoTo

 -

Functions

GoTo

 -

Formulas


 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top