Skip to content
TutorialsForExcel

TutorialsForExcel

Excel Guides and Templates

  • Home
  • How to Guides
  • Functions and Formulas
  • Free Excel Templates

Tag: function

The MAX Function: Syntax and Examples

Posted on February 27, 2019March 11, 2019 by Elora K.
Excel MAX function

The MAX is an Excel statistical function that returns the largest number in a set of values. It will ignore logical and text values. It is one of the oldest Excel functions, so it can be used even with Excel 2003. If you want to include logical values, you’ll need to use the MAXA function.… Read more The MAX Function: Syntax and Examples

The MIN Function: Syntax and Examples

Posted on February 14, 2019February 13, 2019 by Elora K.
MIN function

The MIN is an Excel statistical function that returns the smallest number in a set of values. It will ignore logical and text values. It is one of the oldest Excel functions, so it can be used even with Excel 2003. If you want to include logical values, you’ll need to use the MINA function.… Read more The MIN Function: Syntax and Examples

The SUM Function: Syntax and Examples

Posted on February 13, 2019February 13, 2019 by Elora K.
SUM function

The SUM is an Excel math and trigonometry function that adds values together. It is one of the oldest Excel functions, so it can be used even with Excel 2003. SUM Syntax Required Arguments number1: This is the first number that you want to add. It can be a number, a cell reference or a… Read more The SUM Function: Syntax and Examples

The RAND Function: Syntax and Examples

Posted on February 13, 2019February 13, 2019 by Elora K.
Excel RAND function

The RAND is an Excel math and trigonometry function that returns a random value between 0 and 1. Excel uses the Mersenne Twister algorithm for this. It is one of the oldest Excel functions, so it can be used even with Excel 2003. RAND Syntax Required Arguments The RAND function does not take any arguments.… Read more The RAND Function: Syntax and Examples

Excel Concatenate function examples and common errors

Posted on December 19, 2018February 7, 2019 by Elora K.
how to use the concatenate function

The CONCATENATE function in Excel enables a user to join two or more cells into one. We often need to join the first and last name into a full name or street, house number and city into a full address. One of the easiest ways to complete this is using the Concatenate function. In this tutorial,… Read more Excel Concatenate function examples and common errors

Skip to footer

Newsletter

Get all our latest templates and Excel tips straight to your inbox.

Recent Posts

  • The BETADIST Function: Syntax and Examples
  • The BITOR Function: Syntax and Examples
  • The BIN2HEX Function: Syntax and Examples
  • The COUNT Function: Syntax and Examples
  • How to Freeze Rows and Columns in Excel

Find an Article

Tags

#NUM! #VALUE! 2019 excel template AND bcg matrix BIN2HEX boston matrix boston matrix template CHAR chart clustered column compare CONCAT CONCATENATE conditional formatting consignment invoice duplicates formula function function examples histogram IFERROR investment invoice IRR irregular intervals kpi MATCH math function matrix template OR pivot chart pivot table rail RANK rolling action item list SEARCH slicer sort sort & filter sum template to do list vlookup XIRR
Proudly powered by WordPress | Theme: Yocto by Humble Themes.