Home Excel Functions

Functions

Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

WEEKNUM Function

WEEKNUM Function

0
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1...

MAX Function

0
The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values, TRUE...

NOW Function

0
Learn to use the NOW Function in Excel

SUMIF Function

0
The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common operators...

RAND Function

0
The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel, but can...

HLOOKUP Function in Excel

0
HLOOKUP Function Glossary What is HLOOKUP?HLOOKUP ExampleExact Match vs Approximate Match (False vs True) HLOOKUP from another Workbook or...

EOMONTH Function in Excel

0
Rock the EOMONTH Function in Excel.
YEARFRAC Function

YEARFRAC Function

0
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:

TEXT Function in Excel

0
Learn how to use the TEXT Function in Excel.
WORKDAY Function

WORKDAY Function

0
The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values....

Latest Tutorials

NPER Function

NPER Function

CUMPRINC Function

CUMPRINC Function

YEARFRAC Function

YEARFRAC Function