Excel Topics: Formulas/Functions (Alphabetical)

View Formulas/Functions by Category


Alphabetical Listing of Formulas/Functions:
	Abs	Exact	Or
	ACos	Exp	Percentile
	ACosh	Fact	PercentRank
	Address	False	Permut
	And	FileDateTime (VBA)	Pi
	Areas	FileLen (VBA)	Pmt
	Asc (VBA)	Find	Power
	ASin	Fix (VBA)	PPmt
	ASinh	Fixed	Product
	ATan	Floor	Proper
	ATan2	Forecast	PV
	ATanh	Format Dates (VBA)	Quartile
	Atn (VBA)	Format Numbers (VBA)	Radians
	AveDev	Format Strings (VBA)	Rand
	Average	FV	Rank
	AverageA	GetAttr (VBA)	Rate
	BetaDist	GetPivotData (Ex #1)	Replace
	BetaInv	GetPivotData (Ex #2)	Rept
	BinomDist	Growth	Right
	Case (VBA)	HLookup	Rnd (VBA)
	CBool (VBA)	Hour	Roman
	CByte (VBA)	Hyperlink	Round
	CCur (VBA)	If	RoundDown
	CDate (VBA)	Nested Ifs (up to 7)	RoundUp
	CDbl (VBA)	Nested Ifs (more than 7)	Row
	CDec (VBA)	IF-THEN-ELSE (VBA)	Rows
	Ceiling	Index	RTrim (VBA)
	Cell	Indirect	Search
	Char	Info	Second
	ChDir (VBA)	InStr (VBA)	SetAttr (VBA)
	ChDrive (VBA)	InStrRev (VBA)	Sgn (VBA)
	Choose	Int	Sign
	Chr (VBA)	Intercept	Sin
	CInt (VBA)	IPmt	Sinh
	Clean	Irr	SLn
	CLng (VBA)	IsBlank	Small
	Code	IsDate (VBA)	Space (VBA)
	Column	IsErr	Sqrt
	Columns	IsError	StDev
	Combin	IsLogical	StDevA
	Concatenate	IsNA	StDevP
	Concatenate with &	IsNonText	StDevPA
	Cos	IsNull (VBA)	Str (VBA)
	Cosh	IsNumber	StrConv (VBA)
	Count	IsNumeric (VBA)	Substitute
	CountA	ISPmt	Subtotal
	CountBlank	IsRef	Sum
	CountIf	IsText	SumIf
	Covar	Large	SumProduct
	CSng (VBA)	LCase (VBA)	SumSq
	CStr (VBA)	Left	SumX2mY2
	CurDir (VBA)	Len	SumX2pY2
	CVar (VBA)	Ln	SumXmY2
	Date	Log	Switch (VBA)
	Date (VBA)	Log10	Syd
	DateAdd (VBA)	Lookup	T
	DateDif	Lower	Tan
	DateDiff (VBA)	LTrim (VBA)	Tanh
	DatePart (VBA)	Match	Text
	DateSerial (VBA)	Max	Time
	DateValue	MaxA	TimeSerial (VBA)
	DAverage	Mdeterm	TimeValue
	Day	Median	Today
	Days360	Mid	Transpose
	Db	Min	Trim
	DCount	MinA	True
	DCountA	Minute	Trunc
	DDb	Minverse	Type
	Degrees	MkDir (VBA)	UCase (VBA)
	DGet	Mmult	Upper
	Dir (VBA)	Mirr	Val (VBA)
	DMax	Mod	Value
	DMin	Month	Var
	Dollar	MonthName (VBA)	VarA
	DProduct	N	VarP
	DStDev	NA	VarPA
	DStDevP	Not	Vdb
	DSum	Now	VLookup
	DVar	NPer	Weekday
	DVarP	Npv	WeekdayName (VBA)
	Error.Type	Odd	Year
	Even	Offset

Miscellaneous Functions:
	Two-Dimensional Lookup (Example #1)
	Two-Dimensional Lookup (Example #2)
	Two-Dimensional Lookup (Example #3)
	Two-Dimensional Lookup (Example #4)
	Test a string for an alphanumeric value
	Convert currency into words
	How to Autonumber in Excel
	Delimit values with Ascii 29 character
	Creating a custom round function
	Creating a custom average function (that excludes outlyers from the calculation)