ISNA, ISERROR, and ISBLANK Formula in Excel
Excel has many built-in formulas that will check for errors for you. Were going to take a look at three of those formulas, which are ISNA, ISBLANK and ISERROR. Let’s start by taking a look at the formulas: ISNA(value) ISERROR(value) ISBLANK(value) Each of these formulas looks at value and evaluatues whether it is #N/A (with [...]
COUNTA and COUNTBLANK Formulas in Excel
When using Excel, there will be many instances where you will want to count a particular range of cells. Excel has numerous ways built in already to count that range for you. One way we already explored is through the CountIf Formula, and also the Count Formula. Excel also features the CountA and CountBlank Formulas [...]
Sumif and Countif Formulas in Excel
There are many times when analyzing large amounts of data when you might want to sum or count a column or range based on certain criteria. One example is if you have a database of products you have sold, you might want to know the sum of profits for a particular product – which is [...]
Left, Right and Mid Formulas in Excel
One of the easiest ways to manipulate a string is by using the left, right and mid formulas. There are many times when users of excel are given a long string and only need a certain section of that string to get the results they desire. Using these formulas will greatly reduce the number of [...]
Concatenate Formula in Excel
The Concatenate function is a function that I use almost every day. There are numerous times where you will have data split into many columns but need to look up a value that is unique to the combination of two (or more) of those columns. That is where the concatenate formula comes in handy. Let’s [...]
Loading ...