Skip to content
Aaw Excel- Excel Tips, Tricks & More
Search for...
Navigation Menu
Functions
Logical
AND Function
FALSE Function
NOT Function
XOR Function
Lookup
AREAS Function
HYPERLINK Function
MATCH Function
TRANSPOSE Function
ROWS Function
Dynamic Array
CHOOSECOLS Function
DROP Function
FILTER Function
SORT Function
TEXTSPLIT Function
Text
LEN Function
CLEAN Function
CODE Function
CONCAT Function
DOLLAR Function
EXACT Function
FIND Function
LEFT Function
LOWER Function
MID Function
NUMBERVALUE Function
PROPER Function
REPLACE Function
REPT Function
Right Function
SEARCH Function
SUBSTITUTE Function
TEXTJOIN Function
UNICHAR Function
UNICODE Function
UPPER Function
VALUE Function
Engineering
BIN2DEC Function
BIN2HEX Function
BIN2OCT Function
BITAND Function
BITOR Function
BITXOR Function
BITRSHIFT Function
COMPLEX Function
CONVERT Function
DEC2BIN Function
DEC2HEX Function
DEC2OCT Function
DELTA Function
HEX2BIN Function
HEX2DEC Function
HEX2OCT Function
IMABS Function
IMAGINARY Function
IMPOWER Function
IMPRODUCT Function
IMREAL Function
IMSUB Function
IMSUM Function
Financial
COUPDAYS Function
EFFECT Function
Math
ABS Function
ROUNDUP Function
CEILING.MATH Function
COMBIN Function
COMBINA Function
EVEN Function
MROUND Function
ODD Function
POWER Function
RAND Function
RANDBETWEEN Function
ROUND Function
ROUNDDOWN Function
ROUNDUP Function
SIGN Function
SQRT Function
SUM Function
SUMPRODUCT Function
SUMSQ Function
TRUNC Function
Information
ISFORMULA Function
ISTEXT Function
TYPE Function
Trigonometry
ACOS Function
ATAN2 Function
COSH Function
CSC Function
RADIANS Function
TAN Function
Statistical
AVERAGE Function
AVERAGEA Function
AVERAGEIF Function
AVERAGEIFS Function
COUNT Function
COUNTA Function
COUNTBLANK Function
GEOMEAN Function
MODE.MULT Function
QUARTILE.INC Function
MODE Function
RANK Function
HARMEAN Function
RANK.AVG Function
RANK.EQ Function
LARGE Function
MAX Function
MAXA Function
MAXIFS Function
MEDIAN Function
MIN Function
MINA Function
MINIFS Function
MODE Function
MODE.SNGL Function
MODE.MULT Function
NORM.DIST Function
NORM.INV Function
NORM.S.DIST Function
NORM.S.INV Function
PERCENTILE Function
PERCENTILE.INC Function
PERCENTILE.EXC Function
PERCENTRANK.INC Function
PERMUT Function
QUARTILE Function
QUARTILE.INC Function
QUARTILE.EXC Function
RANK Function
RANK.AVG Function
RANK.EQ Function
SMALL Function
STANDARDIZE Function
STDEV Function
VAR Function
VAR.P Function
VAR.S Function
VARA Function
VARP Function
VARPA Function
Database
DAVERAGE Function
DCOUNT Function
DCOUNTA Function
DGET Function
DMAX Function
DMIN Function
DPRODUCT Function
DSTDEV Function
DSTDEVP Function
DSUM Function
DVAR Function
DVARP Function
Date & Time
DATEVALUE Function
DAY Function
DAYS Function
MINUTE Function
NETWORKDAYS Function
NOW Function
SECOND Function
TIME Function
TODAY Function
WEEKNUM Function
YEAR Function
YEARFRAC Function
Formulas
Count Cells Less than a Given Number
Count Rows that Matches Two or More Criteria
Shortcuts
Close Current Workbook
Kutools
Insert Title Rows into a Range
More
About Us
Contact Us
We are Hiring
Privacy Policy
Sitemap
Aaw Excel- Excel Tips, Tricks & More
Navigation Menu
Navigation Menu
Functions
Logical
AND Function
FALSE Function
NOT Function
XOR Function
Lookup
AREAS Function
HYPERLINK Function
MATCH Function
TRANSPOSE Function
ROWS Function
Dynamic Array
CHOOSECOLS Function
DROP Function
FILTER Function
SORT Function
TEXTSPLIT Function
Text
LEN Function
CLEAN Function
CODE Function
CONCAT Function
DOLLAR Function
EXACT Function
FIND Function
LEFT Function
LOWER Function
MID Function
NUMBERVALUE Function
PROPER Function
REPLACE Function
REPT Function
Right Function
SEARCH Function
SUBSTITUTE Function
TEXTJOIN Function
UNICHAR Function
UNICODE Function
UPPER Function
VALUE Function
Engineering
BIN2DEC Function
BIN2HEX Function
BIN2OCT Function
BITAND Function
BITOR Function
BITXOR Function
BITRSHIFT Function
COMPLEX Function
CONVERT Function
DEC2BIN Function
DEC2HEX Function
DEC2OCT Function
DELTA Function
HEX2BIN Function
HEX2DEC Function
HEX2OCT Function
IMABS Function
IMAGINARY Function
IMPOWER Function
IMPRODUCT Function
IMREAL Function
IMSUB Function
IMSUM Function
Financial
COUPDAYS Function
EFFECT Function
Math
ABS Function
ROUNDUP Function
CEILING.MATH Function
COMBIN Function
COMBINA Function
EVEN Function
MROUND Function
ODD Function
POWER Function
RAND Function
RANDBETWEEN Function
ROUND Function
ROUNDDOWN Function
ROUNDUP Function
SIGN Function
SQRT Function
SUM Function
SUMPRODUCT Function
SUMSQ Function
TRUNC Function
Information
ISFORMULA Function
ISTEXT Function
TYPE Function
Trigonometry
ACOS Function
ATAN2 Function
COSH Function
CSC Function
RADIANS Function
TAN Function
Statistical
AVERAGE Function
AVERAGEA Function
AVERAGEIF Function
AVERAGEIFS Function
COUNT Function
COUNTA Function
COUNTBLANK Function
GEOMEAN Function
MODE.MULT Function
QUARTILE.INC Function
MODE Function
RANK Function
HARMEAN Function
RANK.AVG Function
RANK.EQ Function
LARGE Function
MAX Function
MAXA Function
MAXIFS Function
MEDIAN Function
MIN Function
MINA Function
MINIFS Function
MODE Function
MODE.SNGL Function
MODE.MULT Function
NORM.DIST Function
NORM.INV Function
NORM.S.DIST Function
NORM.S.INV Function
PERCENTILE Function
PERCENTILE.INC Function
PERCENTILE.EXC Function
PERCENTRANK.INC Function
PERMUT Function
QUARTILE Function
QUARTILE.INC Function
QUARTILE.EXC Function
RANK Function
RANK.AVG Function
RANK.EQ Function
SMALL Function
STANDARDIZE Function
STDEV Function
VAR Function
VAR.P Function
VAR.S Function
VARA Function
VARP Function
VARPA Function
Database
DAVERAGE Function
DCOUNT Function
DCOUNTA Function
DGET Function
DMAX Function
DMIN Function
DPRODUCT Function
DSTDEV Function
DSTDEVP Function
DSUM Function
DVAR Function
DVARP Function
Date & Time
DATEVALUE Function
DAY Function
DAYS Function
MINUTE Function
NETWORKDAYS Function
NOW Function
SECOND Function
TIME Function
TODAY Function
WEEKNUM Function
YEAR Function
YEARFRAC Function
Formulas
Count Cells Less than a Given Number
Count Rows that Matches Two or More Criteria
Shortcuts
Close Current Workbook
Kutools
Insert Title Rows into a Range
More
About Us
Contact Us
We are Hiring
Privacy Policy
Sitemap
Contact US
Please enable JavaScript in your browser to complete this form.
Name
*
First
Last
Email
*
Comment or Message
Submit
