TIME function in Excel and it’s related functions are important functions to deal with date-time related data. As these function commonly used with DATE functions, recommend to read an article on DATE functions. TIME function in Excel It returns the time value by taking individual time components (hour, minutes & seconds) as it’s arguments. Using […]
Microsoft Excel – How to convert one date format to another date format?
Microsoft Excel provides flexibility to convert the date(s) into different formats. These dates are either automatically convert based on the system settings or based on the formula used in the cell or based on the format of the cell. Through this article we are going through the ways we can convert the date(s) into different […]
Microsoft Excel – DATE functions
DATE function and related functions are important functions to deal with date related data in Excel. DATE function This function returns the date by taking individual date components (year, month & day) as it’s arguments. Using DATE function we can form the date-time code using the individual date components. Syntax: DATE(year, month, day) DATE function […]
Microsoft Excel – How to generate Random numbers?
Microsoft Excel provides RAND and RANDBETWEEN functions to generate Random numbers. Through this Article we are going to discuss about these two functions. Excel random number generator The RAND function This mathematical function is used to generate random numbers between 0 and 1. For example, 0.469059, 0.677718 etc,. Every time this function generates a new […]
Microsoft Excel – Rounding Numbers to the Specified number of digits
We have discussed rounding the numbers using CEILING and FLOOR functions through my previous Article “Microsoft Excel – CEILING and FLOOR functions“. Excel provides another set of functions; provides a similar kind of functionality to round the numbers. Through this article, we are going to discuss these functions. ROUND, ROUNDUP and ROUNDDOWN functions in Excel […]
Microsoft Excel – CEILING and FLOOR functions
As part of Excel functions discussions, we are going to discuss about two functions through this Article; which are CEILING and FLOOR functions. The CEILING function This function returns the rounded up number which is nearest to the specified multiple of significance. It is important to understand that, the return number is based on the […]
Microsoft Excel – Text Functions – MID and MIDB formulas
We have discussed in our Previous Article on how to extract partial text in Excel using LEFT, LEFTB and RIGHT, RIGHTB functions. In this Article, we will discuss another set of Text Functions in Microsoft Excel for the same purpose; to extract partial text from the given text. MID and MIDB functions MID and MIDB […]
Microsoft Excel – Text Functions – T and TEXT formulas
Microsoft Excel provides T and TEXT functions to display the text and format the numeric value, respectively. We will discuss about these functions in this Article. The T function This function is used to return the text from the given value. Truly speaking, this doesn’t convert the value to the text; instead it returns the […]
Microsoft Excel – Text Functions – EXACT, FIND and FINDB formulas
In this Article, we will discuss about another set of useful Text Functions Microsoft Excel provides to search the text in the given text. The EXACT formula This function is used to compare two given text values and returns TRUE if both the values are match. The comparison is case-sensitive. That means, “Apple” and “apple” […]
Microsoft Excel – Text Functions – SEARCH and SEARCHB formulas
Another set of Text functions SEARCH and SEARCHB in Microsoft Excel are useful to find the text within the given text. These functions returns the index value where it finds the text in the given text. These functions are non case-sensitive. That means, these considers the text “APPLE” and “apple” as same. SEARCH formula This […]