Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Excel Formulas Examples | ExtendOffice


Count
Count cells equal to COUNTIFSUMPRODUCTEXACT
Count cells not equal to COUNTIF
Count cells equal to either x or y COUNTIFSUMPRODUCTSUM
Count cells equal to both x and y COUNTIFS
Count cells greater than or less than COUNTIF
Financial
Calculate interest payments per period or total IPMTCUMIPMT
Lookup
Lookup closest match value with multiple criteria IFMATCHINDEX
Lookup values from another worksheet or workbook VLOOKUP
Vlookup with dymanic sheet name VLOOKUPINDIRECT
Shipping cost calculator VLOOKUP
Dynamic worksheet or workbook reference INDIRECT
Math
Convert binary value to decimal or octal or hex value BIN2DECDECIMALBIN2OCTBIN2HEX
Convert hexadecimal value to decimal or binary or octal value HEX2DECDECIMALHEX2OCTHEX2BIN
Convert octal value to decimal or binary or hexadecimal value OCT2DECDECIMALOCT2HEXOCT2BIN
Convert decimal value to binary or octal or hexadecimal value DEC2DECDEC2OCTDEC2HEX
Convert decimal number to IP address MID
Convert decimal to whole number in Excel ROUND ROUNDDOWN ROUNDUP
Date and Time
Extract time only from datetime in Excel TIMEMOD
Extract date only from datetime in Excel INTTRUNC DATE
Get week number from date in Excel WEEKNUM
Get work hours between two dates in Excel NETWORKDAYS NETWORKDAYS.INTL
Get or calculate age from birth date in Excel YEARFRAC DATEDIF