Excel Topics: Formulas/Functions (Alphabetical)

View Formulas/Functions by Category


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

Miscellaneous Functions:
	Two-Dimensional Lookup (Example #1)
	Two-Dimensional Lookup (Example #2)
	Two-Dimensional Lookup (Example #3)
	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)

Excel Topics: Formulas/Functions (Alphabetical)

Spreadsheet News

Book Shop

Sponsors Links