by Ilker | Nov 19, 2020 | Excel Formulas
The DEC2HEX is an Engineering function that converts a hexadecimal number into a decimal number. In this guide, we’re going to show you how to use the DEC2HEX function and also go over some tips and error handling methods. Supported versions All Excel versions DEC2HEX...
by Ilker | Nov 19, 2020 | Excel Formulas
The HEX2DEC is an Engineering function that converts a hexadecimal number to decimal. In this guide, we’re going to show you how to use the HEX2DEC function and also go over some tips and error handling methods. Supported versions All Excel versions HEX2DEC Syntax...
by Ilker | Sep 21, 2020 | Excel Formulas
The CELL is an Information function that returns information about various properties of a cell. You can learn things like file name with full folder path, location of a cell or formatting properties. In this guide, we’re going to show you how to use the CELL function...
by Ilker | Sep 10, 2020 | Excel Formulas
The YEARFRAC is a Date & Time function that calculates and returns the fraction of the year between two days. The function calculates the fraction by the number of whole days in given day count basis. In this guide, we’re going to show you how to use the YEARFRAC...
by Ilker | Jul 28, 2020 | Excel Formulas, Excel Tips & Tricks
You can use Excel formulas to populate a random number or string from a list. You can even build a logic to return numbers without any duplicates. In this article, we are going to show you how to select a random Item from a list in Excel. Download Workbook Although...
by Ilker | Jul 2, 2020 | Excel Formulas
The STANDARDIZE Excel function is a Statistical formla that calculates and returns normalized value (z-score) based on the mean and standard deviation of a data set. In this guide, we’re going to show you how to use the STANDARDIZE function and also go over some tips...
by Ilker | Nov 22, 2019 | Excel Formulas
RANK.AVG (RANK AVG) is a Statistical function that can return the rank of a given value, within the specified array of values. If there are values that share the same rank, the average rank of that set of values will be returned. In this guide, we’re going to show you...
by Ilker | Nov 22, 2019 | Excel Formulas
The RANK.EQ function is a Statistical formula that returns the rank of a given value, within the specified array of values. If there is more than one values that share the same rank, the higher rank of that set of values is going to be returned by the formula. In this...
by Ilker | Nov 21, 2019 | Excel Formulas
The AVERAGEA in Excel is a Statistical function that can calculate and return the average (arithmetic mean) of the values of a range of cells. AVERAGEA differs from the AVERAGE function in its ability to include numbers in string format and logical values in the...
