In this article, we will learn how to use EXACT function in Microsoft Excel. In Excel, EXACT function compares two text strings and return TRUE if they match exactly. Otherwise, it returns FALSE. EXACT is a case-sensitive function, and it … Continue reading
In this article, we will learn about FALSE function in Microsoft Excel. In Excel, FALSE function returns the Boolean value FALSE. FALSE does not take any argument, and we can either type the word FALSE directly onto the worksheet or … Continue reading
In this article, we’ll learn about LARGE function in Microsoft Excel. In Microsoft Excel, LARGE function returns the k’th largest value from an array or set of data. With the help of examples, let us understand the use of … Continue reading
In this article, we’ll learn how to use COUNT function in Microsoft Excel. In Excel COUNT Function returns the number of cells that contain numerical values, including numbers and dates from a set of data. We can either supply values … Continue reading
In this article, we are going to learn about how and where we use AND function of Microsoft Excel. Microsoft Excel AND function tests multiple conditions at the same time, up to 255 conditions and only if all conditions … Continue reading
In this article we will learn how to calculate the investment value for future or annuity for the present value by using the functions of Microsoft Excel. When we made investment, the amount paid is entered in negative value so … Continue reading
If you are required to add particular numbers with specific length in a range then you can make use of data validation. In this article, we will focus on extensive use of data validation custom feature to allow user to … Continue reading
How to Get Position Of Last Occurrence of Symbol In Microsoft Excel If you want to know the position of a symbol in Excel then you should read this article. In this article, we will learn how to find position … Continue reading
How to Combine First and Last Name Ignoring Middle Name in Microsoft Excel If you have a list of names in all sort of different formats & you are supposed to quickly extract a list of names; in case you … Continue reading
In case we are using nested IF formula & we all know nested IF takes a lot of time in calculating the result. In this article, we will learn how we can avoid using nested IF function. Question: I … Continue reading
