by Ilker | Mar 15, 2019 | Excel Formulas
The RANDBETWEEN function returns a random integer number between the numbers specified. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax...
by Ilker | Mar 15, 2019 | Excel Formulas
The RAND function returns an evenly distributed random numbers greater than or equal to 0 and less than 1. In this guide, we’re going to show you how to use the RAND function and also go over some tips and error handling methods. Supported versions All Excel versions...
by Ilker | Mar 14, 2019 | Excel Formulas
The Excel SUBTOTAL function returns the subtotal of the specified values. The function works like a combination of aggregation formulas of Excel, and allows you to determine the function with the use of a separate parameter. What separates the SUBTOTAL function from...
by Ilker | Mar 11, 2019 | Excel Formulas
COUNT is a statistics function that counts the numeric values within the specified range. A common use case for this function is counting the cells that have numeric values. In this guide, we’re going to show you how to use the COUNT function and also go over some...
by Ilker | Mar 7, 2019 | Excel Formulas
The MINIFS is a statistics function that returns the minimum value of only the cells that meet certain criteria. In this guide, we’re going to show you how to use the Excel MINIFS function and also go over some tips and error handling methods. Supported Excel versions...
by Ilker | Mar 7, 2019 | Excel Formulas
The MAXIFS Excel function is a statistics formula that returns the maximum value of only the cells that meet certain criteria. In this guide, we’re going to show you how to use the MAXIFS function and also go over some tips and error handling methods. Supported Excel...
by Ilker | Mar 6, 2019 | Excel Formulas
The Excel COUNTA function is a statistics formula that returns the number of cells in a range containing numbers, text, logical values, error values, and empty text (“”). In this guide, we’re going to show you how to use the Excel COUNTA function and also...
by Ilker | Mar 5, 2019 | Excel Formulas
The Excel INDIRECT function is a Lookup & Reference formula that returns the reference specified by a text string. It is useful for when you want to convert text strings into valid references. In this guide, we’re going to show you how to use the Excel INDIRECT...
by Ilker | Feb 21, 2019 | Excel Formulas
With the dynamic arrays concept, formulas that return an array can spill the results to the neighboring cells automatically. However, this behavior conflicts with legacy implicit intersection formulas that use ranges (arrays). For the sake of backward compatibility,...
