In this article, you’ll learn how to multiply the time values and numbers in Microsoft Excel. To calculate the payment based on the worked hours & rate, we have to multiply each time value by its matching numerical rate. … Continue reading →

The three new IFS functions are: The AVERAGEIFS function returns the average (arithmetic mean) of all cells that meet multiple criteria. The SUMIFS function adds the cells in a range that meet multiple criteria. The COUNTIFS function counts the number … Continue reading →

In this article, we are going to learn to calculate the Absolute difference between each list and the Minimum Value in the list. To solve this problem, we will use ABS and MIN function. ABS function is used to return … Continue reading →

Problem: Column A contains a list of numbers. We want to find the minimum value in the range between row 2 (first value in the list) and each row number specified in column B. Solution: Use the MIN and INDIRECT … Continue reading →

BASE function With Excel 2013, Microsoft has launched a new function i.e BASE function which converts a number into a text representation with the given base. Syntax:- =BASE(Number, Radix [Min_length]) Where, Number is the number which you want … Continue reading →

To intentionally use a Circular Reference: In this example, a Value-added tax (VAT) gross-up formula is in cell B1 (the formula is =B3-B2). 1. In cell A2, enter the VAT percent (%) 0.20. 2. In cell B2, insert the formula … Continue reading →

In this article we will learn how to count the number of values between two specified values in a list in Microsoft Excel 2010. If we need to count the values in a range that fall in between two numbers, … Continue reading →

SKEW.P Function Excel 2013 has introduced a new function i.e., SKEW.P function. This function returns the skewness of a distribution based on a population. Syntax:- SKEWP(number 1, [number 2],…) where number 1, number 2 are the reference to … Continue reading →

In this chapter, you’ll learn about how to adjust values returned by RAND function. RAND function provide us the random numbers and it gets changed every time by doing any activity in the worksheet. Let’s take an example and … Continue reading →

Decimal Function Decimal function has been introduced with Excel 2013 and it converts a text representation of a number in a given base into a decimal number. Syntax:- =DECIMAL(text, radix) where, text is the text representation of number … Continue reading →