Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples
If you want to test more than one condition then you need to use the If statement. The “If Statement” is used in many programming languages. The Excel users also …
Formulas
How to Remove Dashes (-) in Excel?
Sometimes, you may get data (text or numbers) that have dashes (or hyphens) in it. If you want to remove these dashes in Excel, you can use a couple of …
What does $ (dollar sign) mean in Excel Formulas?
If you have worked with Excel formulas, I am sure you have noticed that sometimes there is a $ symbol as a part of the cell references. If you’re wondering …
How to use Excel If Statement with Multiple Conditions Range [AND/OR]
To perform complicated and powerful data analysis, you need to test various conditions at a single point in time. The data analysis might require logical tests also within these multiple …
How to Print Row Numbers in Excel (3 Easy Ways)
When printing out an Excel worksheet, we usually just need to see the data. We don’t really care much for the location of the data, neither do we want to …
How to Sum Positive Numbers in Excel – Easy Formula
For someone fairly comfortable with Excel, summing up a list of cells is as easy as pie. But when it comes to summing up cells based on a particular condition, …
How to Count Negative Numbers in Excel – Easy Formula
Counting cells in a range of data is fairly easy, even if you are a beginner at Excel. But when it comes to counting only the cells that contain a …
How to Convert Date to Day of Week in Excel (3 Easy Ways)
When working with date-specific information, there might be instances where you need to find the day of the week corresponding to a date. For example, instead of the date, …
How to Convert Serial Numbers to Date in Excel
When you bring in data from other sources, it is not uncommon to get the dates in the form of serial numbers, like 42088. Moreover, Excel inherently stores dates in …
How to Remove a Specific Character from a String in Excel
A big part of processing data involves the cleaning of the data. Most data you bring in to Excel often comes from various sources. Many times they are converted from …
How to Convert Date to Month and Year in Excel (3 Easy Ways)
Whenever you enter a date in a cell, Excel automatically recognizes the format and converts the cell to a date cell. So, Excel knows which part of the date you …
How to Add Text to the Beginning or End of all Cells in Excel
There may be instances where you need to add the same text to all cells in a column. You might need to add a particular title before names in a …