Excel ABS

How to Average Absolute Values in Excel

We can use AVERAGE function to calculate average of certain values. We can use ABS function to get absolute values for both positive number and negative number. If we want to get the average absolute values, we need to combine both above two functions in the formula. In this free tutorial, we will provide two… read more »

How to Get the Maximum or Minimum Absolute Value in Excel

It is easy to find the maximum or minimum value in a batch of data in excel, but if this batch of numbers contains both positive and negative numbers, the maximum or minimum absolute value cannot be found out by basic MAX or MIN function in excel. This article will help you to solve this… read more »

How to Change Negative Numbers to Positive in Excel

This post will guide you how to change all negative numbers to positive in Excel 2013/2016. How do I remove negative sign to a number in cells with a formula in Excel. Change Negative Numbers to Positive with a Formula Change Negative Numbers to Positive with Find and Replace function Change Negative Numbers to Positive… read more »

Calculating Discount Rate

This post will guide you how to calculate discount rate based on the discounted price and the original price in Excel. How do I generate percentage discount rate with a formula in Excel. How to calculate discount price in Excel. Calculating Discount Rate Assuming that you have a list of data in range A1:B4 that… read more »

Sum the Absolute Values in Excel

This post will guide you how to sum the absolute values in a range of cells in Excel. How do I sum the absolute values with a formula in Excel 2013/2016. Sum the Absolute Values Assuming that you have a list of data in range B1:B6 that contain negative numbers and positive numbers, and you… read more »

Find Closest Value or Nearest Value in a Range in Excel

This post will guide you how to find the closest value or nearest value in a range of cells or in a column in Excel. How do I find the closest match in a range to a given lookup value in Excel. How to find the closest larger and closest smaller values from a range… read more »

Excel SQRT Function

This post will guide you how to use Excel SQRT function with syntax and examples in Microsoft excel. Description The Excel SQRT function returns the square root of a positive number. And if you provide a negative number, the function will return #NUM! Error. The SQRT function is a build-in function in Microsoft Excel and… read more »

Excel IF Function With Numbers

Normally, If you want to write an IF formula for numbers in combining with the  logical operators in excel, such as: greater than, less than, greater than or equal to, less than or equal to, equal to, not equal to.etc. The generic IF formula with logical operator for number values is as below: =IF(B1>10,”good”,”bad”) Excel… read more »

Excel ABS Function

This post will guide you how to use Excel ABS function with syntax and examples in Microsoft excel. Description The Excel ABS function returns the absolute value of a number The ABS function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function. The ABS function is available in Excel… read more »

Sidebar