RANK function is used to compare numbers to other numbers in the same list. RANK function will tell you the rank of a given number from a range of number in ascending or descending order. Syntax =RANK(number or cell address, ref, (order)) This function is used at various places like schools for Grading, Salesman Performance […]

In this article today, we will discuss some common text functions like UPPER, LOWER and PROPER which we can use to convert our text to lowercase, uppercase or proper as required. Excel has many built-in functions related to text operations Text category. Once we start working with a few, we can work on others quite […]

Today I will show you how to round up values using ROUND, ROUNDDOWN, and ROUNDUP functions. Using the above functions for rounding will change the value of the number and the display of the number in the worksheet as per the given argument. Let’s understand each in detail with relevant examples. ROUND Function ROUND function […]

Let’s discuss ways to convert values from positives to negatives and vice versa by using Paste Special, Find and Replace, ABS Function and Custom Formatting. Let’s begin with Paste Special technique. 1. Paste Special Technique The function name itself says that it is special. The reason why it is so special is that it can […]

In our previous post “10 Basic Excel Functions That Everyone Should Know” we learned how to use the =CONCATENATE() function. Concatenate merges data of different cells into one cell. What if I want to split the data of a cell into multiple cells or in other words how to reverse the concatenate function? For example, I […]