SpellNumber is a manually created function through VBA Programming to change a number to written text. In other words, it converts a numeric value into English words with currency. In this article, we will learn step by step how to create this SpellNumber function using the VBA Function. For example, I have $ 2,345.50 and […]

We discussed rounding of floating values using ROUND, ROUNDUP and ROUNDDOWN functions. What if I want these rounding of numbers to be even or odd? Today, we will learn how to round values using EVEN, ODD, CEILING and FLOOR Functions. Let’s understand each of these functions with some examples. EVEN Using EVEN function, a number […]

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 […]