by Ilker | Nov 12, 2018 | Excel Formulas
The UPPER function converts a text into uppercase. In this guide, we’re going to show you how to use this function and cover some tips and error handling methods.Supported versionsAll Excel versionsSyntax UPPER(text)ArgumentstextThe text you want converted to...
by Ilker | Nov 8, 2018 | Excel Formulas
The IF function performs a logical test (specified from its first argument), and returns either one of its second or third argument depending on the result of the test. If the test returns TRUE, the result will be the second argument, otherwise it will be the third....
by Ilker | Nov 7, 2018 | Excel Formulas
HLOOKUP function is a lookup and reference function that can search a specific information in a selected table. In this guide, we’re going to show you how to use the HLOOKUP function and also go through some tips and error handling methods. The HLOOKUP searches a...
by Ilker | Nov 7, 2018 | Excel Formulas
VLOOKUP function is a lookup and reference function that can search a specific information in a table. In this guide, we’re going to show you how to use the VLOOKUP function and also add some tips and error handling methods. The VLOOKUP searches a value in the first...
by Ilker | Oct 26, 2018 | Excel Formulas
AVERAGIFS function can calculate the average in a range of cells, based on a criteria. In this guide, we’re going to show you how to use the AVERAGIFS function and go through some examples, as well as error handling methods. Supported versions (Windows) Excel 2007 and...
by Ilker | Oct 26, 2018 | Excel Formulas
COUNTIFS function can count the values in a range of cells, based on some criteria. In this guide, we’re going to show you how to use the COUNTIFS function and cover some examples and error handling methods. Supported versions (Windows) Excel 2007 and above (Mac)...
by Ilker | Oct 24, 2018 | Excel Formulas
SUMIFS function can sum up the values in a range of cells, based on some criteria. In this guide, we’re going to show you how to use the SUMIFS function and cover some examples and error handling methods. Supported versions (Windows) Excel 2007 and above (Mac) Excel...