FunctionFunction SyntaxFunction Category
AverageAverage(Num1, Num2, …)Statistical Function
AverageaAveragea(Num1, Num2, …)Statistical Function
AverageifAverageif(Range, Criteria, [Range])Statistical Function
AverageifsAverageifs(Range, Range1, Criteria1, [Range2, Criteria2], …)Statistical Function
ConcatenateConcatenate (Cell 1, Cell 2…)Statistical Function
CountCount(Value1, [Value2], …)Statistical Function
CountaCounta(Value1, [Value2], ...)Statistical Function
CountblankCountblank(Range)Statistical Function
CountifsCountifs(Range 1, Criteria 1, Range 2, Criteria 2…)Statistical Function
FrequencyFrequency(Data_Array, Bins_Array)Statistical Function
LargeLarge(Array, K)Statistical Function
MaxMax(Num1, [Num2], …)Statistical Function
MaxaMaxa(Num1, [Num2], …)Statistical Function
MedianMedian(Num1, [Num2], …)Statistical Function
MinMin(Num1, [Num2], …)Statistical Function
MinaMina(Num1, [Num2], …)Statistical Function
Rank.AvgRank.Avg(Num, Ref, [Order])Statistical Function
SmallSmall(Array, K)Statistical Function
CountifCount(Value 1, Value 2…)Statistical Function
CountifCountif(Range, Criteria)Statistical Function
CharChar(Num)Text Function
CleanClean(Text)Text Function
CodeCode(Text)Text Function
ConcatenateConcatenate (Cell 1, Cell 2…)Text Function
DollarDollar(Num, [Decimals])Text Function
ExactExact(Text1, Text2)Text Function
FindbFindb(Find_Text, Within_Text, [Start_Num])Text Function
FindFind(Find_Text, Within_Text, [Start_Num])Text Function
FixedFixed(Num, [Decimals], [No_Commas])Text Function
LeftbLeftb(Text, [Num_Chars])Text Function
LeftLeft(Text, [Num_Chars])Text Function
LenbLenb(Text)Text Function
LenLen(Text)Text Function
LowerLower(Text)Text Function
MidbMidb(Text, Start_Num, Num_Bytes)Text Function
MidMid(Text, Start_Num, Num_Chars)Text Function
ProperProper(Text)Text Function
ReplacebReplaceb(Old_Text, Start_Num, Num_Bytes, New_Text)Text Function
ReplaceReplace(Old_Text, Start_Num, Num_Chars, New_Text)Text Function
ReptRept(Text, Num_Times)Text Function
RightbRightb(Text,[Num_Bytes])Text Function
RightRight(Text,[Num_Chars])Text Function
SearchbSearchb(Find_Text,Within_Text,[Start_Num])Text Function
SearchSearch(Find_Text,Within_Text,[Start_Num])Text Function
SubstituteSubstitute(Text, Old, New, [Instance_Num])Text Function
TT(Text)Text Function
TextText(Value, Format_Text)Text Function
TrimTrim(Text)Text Function
UpperUpper(Text)Text Function
ValueValue(Text)Text Function
AbsAbs(Num)Math and Trigonometrys
BaseBase(Num, Radix [Min_Length])Math and Trigonometrys
CeilingCeiling(Num, Significance)Math and Trigonometrys
Ceiling.PreciseCeiling.Precise(Num, Significance)Math and Trigonometrys
CombinCombin(Num, Num_Chosen)Math and Trigonometrys
CombinaCombina(Num, Num_Chosen)Math and Trigonometrys
DecimalDecimal(Text, Radix)Math and Trigonometrys
DegreesDegrees(Angle)Math and Trigonometrys
EvenEven(Num)Math and Trigonometrys
ExpExp(Num)Math and Trigonometrys
FactFact(Num)Math and Trigonometrys
FactdoubleFactdouble(Num)Math and Trigonometrys
FloorFloor(Num, Significance)Math and Trigonometrys
Floor.PreciseFloor.Precise(Num, [Significance])Math and Trigonometrys
IntInt(Num)Math and Trigonometrys
LnLn(Num)Math and Trigonometrys
LogLog(Num, [Base])Math and Trigonometrys
Log10Log10(Num)Math and Trigonometrys
ModMod(Num, Divisor)Math and Trigonometrys
MroundMround(Num, Multiple)Math and Trigonometrys
OddOdd(Num)Math and Trigonometrys
PiPi()Math and Trigonometrys
PowerPower(Num, Power)Math and Trigonometrys
ProductProduct(Num1, [Num2], …)Math and Trigonometrys
QuotientQuotient(Numerator, Denominator)Math and Trigonometrys
RadiansRadians(Angle)Math and Trigonometrys
RandRand()Math and Trigonometrys
RandbetweenRandbetween(Bottom, Top)Math and Trigonometrys
RomanRoman(Num, [Form])Math and Trigonometrys
RoundRound(Num, Num_Digits)Math and Trigonometrys
RounddownRounddown(Num, Num_Digits)Math and Trigonometrys
RoundupRoundup(Num, Num_Digits)Math and Trigonometrys
SqrtSqrt(Num)Math and Trigonometrys
SqrtpiSqrtpi(Num)Math and Trigonometrys
SumSum(Num1,[Num2],…)Math and Trigonometrys
SumifSumif(Range, Criteria, [Sum_Range])Math and Trigonometrys
SumifsSumifs(Sum_Range, Range1, Criteria1, [Range2, Criteria2], …)Math and Trigonometrys
SumproductSumproduct(Array1, [Array2], [Array3], …)Math and Trigonometrys
SumsqSumsq(Num1, [Num2], …)Math and Trigonometrys
Sumx2My2Sumx2My2(Array_X, Array_Y)Math and Trigonometrys
Sumx2Py2Sumx2Py2(Array_X, Array_Y)Math and Trigonometrys
Sumxmy2Sumxmy2(Array_X, Array_Y)Math and Trigonometrys
TruncTrunc(Num, [Num_Digits])Math and Trigonometrys
AcosAcos(Num)Math and Trigonometrys
AcoshAcosh(Num)Math and Trigonometrys
AcotAcot(Num)Math and Trigonometrys
AcothAcoth(Num)Math and Trigonometrys
AsinAsin(Num)Math and Trigonometrys
AsinhAsinh(Num)Math and Trigonometrys
AtanAtan(Num)Math and Trigonometrys
Atan2Atan2(X_Num, Y_Num)Math and Trigonometrys
AtanhAtanh(Num)Math and Trigonometrys
CosCos(Num)Math and Trigonometrys
CoshCosh(Num)Math and Trigonometrys
CschCsch(Num)Math and Trigonometrys
SechSech(Num)Math and Trigonometrys
SinSin(Num)Math and Trigonometrys
SinhSinh(Num)Math and Trigonometrys
TanTan(Num)Math and Trigonometrys
TanhTanh(Num)Math and Trigonometrys
DateDate(Year,Month,Day)Date and Times
DatedifDatedif(Start_Date,End_Date,Unit)Date and Times
DatevalueDatevalue(Date_Text)Date and Times
DayDay(Serial_Num)Date and Times
Days360Days360(Start,End,[Method])Date and Times
EdateEdate(Start_Date, Months)Date and Times
EomonthEomonth(Start_Date, Months)Date and Times
HourHour(Serial_Num)Date and Times
IsoweeknumIsoweeknum(Date)Date and Times
MinuteMinute(Serial_Num)Date and Times
MonthMonth(Serial_Num)Date and Times
NetworkdaysNetworkdays(Start_Date, End_Date, [Holidays])Date and Times
Networkdays.IntlNetworkdays.Intl(Start, End, [Weekend], [Holidays])Date and Times
NowNow()Date and Times
SecondSecond(Serial_Num)Date and Times
TimeTime(Hour, Minute, Second)Date and Times
TimevalueTimevalue(Time_Text)Date and Times
TodayToday()Date and Times
WeekdayWeekday(Serial_Num,[Return_Type])Date and Times
WeeknumWeeknum(Serial_Num,[Return_Type])Date and Times
WorkdayWorkday(Start_Date, Days, [Holidays])Date and Times
Workday.IntlWorkday.Intl(Start_Date, Days, [Weekend], [Holidays])Date and Times
YearYear(Serial_Num)Date and Times
YearfracYearfrac(Start_Date, End_Date, [Basis])Date and Times
AndAnd(Logical1, [Logical2], …)Logical Functions
FalseFalse()Logical Functions
IfIf(Logical_Test, Value_If_True, [Value_If_False])Logical Functions
IferrorIferror(Value, Value_If_Error)Logical Functions
IfnaIfna(Value, Value_If_Na)Logical Functions
NotNot(Logical)Logical Functions
OrOr(Logical1, [Logical2], …)Logical Functions
TrueTrue()Logical Functions
AddressAddress(Row_Num, Column_Num, [Abs_Num], [A1], [Sheet_Text])Lookup and References
AreasAreas(Array)Lookup and References
ChooseChoose(Index_Num, Value1, [Value2], …)Lookup and References
ColumnColumn([Reference])Lookup and References
ColumnsColumns(Array)Lookup and References
HlookupHlookup(Value, Array, Row_Num, [Range])Lookup and References
HyperlinkHyperlink(Link_Location, [Friendly_Name])Lookup and References
IndexIndex(Array, Row_Num, [Column_Num])Lookup and References
IndirectIndirect(Ref_Text, [A1])Lookup and References
LookupLookup(Lookup_Value, Lookup_Vector, [Result_Vector])Lookup and References
MatchMatch(Lookup_Value, Lookup_Array, [Match_Type])Lookup and References
OffsetOffset(Reference, Rows, Cols, [Height], [Width])Lookup and References
RowRow([Reference])Lookup and References
RowsRows(Array)Lookup and References
TransposeTranspose(Array)Lookup and References
VlookupVlookup(Value, Range, Column Num, Match Logic)Lookup and References