Posts Tagged 'Excel formulas', page 4
Excel IF OR function with formula examples
IF is one of the most popular Excel functions and very useful on its own. Combined with the logical functions such as AND, OR, and NOT, the IF function has even more value because it allows you to test multiple conditions in desired combinations. Continue reading
How to subtract in Excel: formula for numbers, percentages, dates and times
Subtraction is one of the four basic arithmetic operations, and every primary school pupil knows that to subtract one number from another you use the minus sign. This good old method also works for subtracting numbers and cells in Excel. Continue reading
Excel TRANSPOSE function to rotate data from columns to rows
Some Excel users prefer organizing data vertically in columns while others choose horizontal arrangement in rows. In situations when you need to quickly change the orientation of a given range, TRANSPOSE is the function to use. Continue reading
How to use LINEST function in Excel - formula examples
In this tutorial, intended for beginners, we will touch only lightly on theory and calculations behind the Excel LINEST function. Our main focus will be on providing you with a formula that simply works and which you can easily customize for your data. Continue reading
How to convert text to number in Excel
Sometimes values in your Excel worksheets look like numbers, but they don't add up, don't multiply and produce errors in formulas. A common reason for this is numbers formatted as text. This tutorial will teach you how to convert numeric strings to actual numbers. Continue reading
Excel VALUE function to convert text to numbers
Normally, Microsoft Excel recognizes numbers stored as text and converts them to the numerical format automatically. However, if the data is in a format that Excel cannot recognize, numeric values can be left as text making calculations impossible. Continue reading
How to get absolute value in Excel: ABS function with formula examples
One of the fundamental things we know about numbers is that they can be positive and negative. But sometimes you may need to use only positive numbers, and that's where the absolute value comes in handy. Continue reading
Calculate and highlight 90/60/30 days from or before today in Excel
Are you looking to calculate the expiration date that is exactly 90 days from now? Or you need to know the date that occurred 60 days before today? Whatever your task is, this tutorial will teach you how to make your own date calculator in Excel in under 5 minutes. Continue reading
Excel COUNTIF and COUNTIFS with OR conditions
As everyone knows, Excel COUNTIF function is designed to count cells based on just one criterion while COUNTIFS evaluates multiple criteria with AND logic. But what if your task requires OR logic – when several conditions are provided, any one can match to be included in the count? Continue reading
How to calculate days between dates in Excel
Are you wondering how many days are between two dates? Maybe, you need to know the number of days between today and some specific date in the past or future? Or, you just want to count working days between two dates? Whatever your task is, one of the below examples will certainly provide the solution. Continue reading
IFERROR with VLOOKUP in Excel - elegant way to trap #N/A errors
Excel VLOOKUP and IFERROR - these two functions may be pretty hard to understand separately, let alone when they are combined. In this article, you will find a few easy-to-follow examples that address common uses and clearly illustrate the formula logic. Continue reading
VLOOKUP with IF statement in Excel
Whilst VLOOKUP and IF functions are useful on their own, together they deliver even more valuable experiences. Today, we will be looking at a few simple examples that will show you how to Vlookup with If condition in Excel. Continue reading
How to separate names in Excel: split first and last name into different columns
It is a very common situation in Excel that your worksheet contains a column of full names, and you want to split the first and last names into separate columns. The task can be accomplished in three different ways - by using the Text to Columns feature, formulas, and Split Names tool. Continue reading
Video: Excel date formulas made easy
This video will show you how to get Excel date formulas of any complexity without actually writing them. Learn how you can find the number of days between two dates, calculate age, add and subtract dates in Excel with your personal date&time formula assistant. Continue reading
How to extract number from string in Excel
To extract number from string in Excel, it'd take a little ingenuity, a bit of patience, and a bunch of different functions nested into each other. Or, you can run the Extract tool and have the job done with a mouse click. Continue reading
Excel substring: how to extract text from cell
Although there is no such thing as Substring function in Excel, there exist three Text functions to extract text of a given length from a cell. Additionally, there are FIND and SEARCH functions to get a substring before or after a specific character. Continue reading
How to divide in Excel and handle #DIV/0! error
As with other basic math operations, Microsoft Excel provides several ways to divide numbers and cells. Which one to use depends on your personal preferences and a particular task you need to solve. Continue reading
Excel: If cell contains then count, sum, highlight, copy or delete
In our previous tutorial, we were looking at Excel If contains formulas that return some value to another column if the target cell contains a specific value. Aside from that, what else can you do if a cell contains certain text or number? Continue reading
Excel: If cell contains formula examples
One of the most common tasks in Excel is checking whether a cell contains a value of interest. What kind of value can that be? Just any text or number, specific text, or any value at all (not empty cell). Continue reading
How to multiply columns in Excel
As with all basic arithmetic operations, there is more than one way to multiply columns in Excel. This tutorial will show you a few possible solutions so you can choose the one that works best for you. Continue reading
