#DIV/0! Division by Zero Error in Excel

Posted on March 17th, 2009 by Joseph Harris

The #DIV/0! error happens when the denominator (the number on the bottom) of an equation is zero. Many times you will want to display a 0 or NULL rather than the #DIV/0! error. Below is a simple way to accomplish this. Rather than entering =A1/B1, use =if(B1=0,0,A1/B1), if you want a NULL to appear rather [...]

Multiple Condition Vlookup Function Add-in – Excel

Posted on March 16th, 2009 by Joseph Harris

The question we are asked most often by ExcelYogi readers is how can I use vlookup with multiple criteria or conditions. There are several solutions but some can be pain staking and unrealistic. Knowing that the Excel world is missing this feature, Excel Yogi has created a VLookup addin that will extend the built in [...]

Scrolling Excel Charts – Scroll Bar Graphs

Posted on March 13th, 2009 by Joseph Harris

There are many times when you may have a lot of data that does not look right when graphed all together. 300 data points is probably too many for a small chart. So what is the solution…scrolling charts! I will show you in this article how to create a scrolling chart without using dynamic ranges. [...]

Excel Tutorials – Microsoft Excel Video Professor

Posted on March 13th, 2009 by Joseph Harris

While compiling videos for the Excel tutorials section of ExcelYogi, I came across Excel Video Professor. After reading about it, I decided to see if it was any good, so I ordered it for free here: Free Video Professor. The shipping was very fast, I ordered the Excel training on a Thursday and received it [...]

Removing Characters from a String in Excel

Posted on March 3rd, 2009 by Joseph Harris

It is often necessary to replace characters within a string in Excel with other characters. Or you may want to remove some characters entirely. There are several ways to do this but by far the easiest method is to use the built-in replace tool. For example, you have the following in a cell: 610-555-2904 You want to [...]

#VALUE! Error in Microsoft Excel

Posted on March 3rd, 2009 by Joseph Harris

The #VALUE error is an error that is seen almost as often as #N/A. In short, the VALUE error occurs when a formula refers to a cell that contains a different than expected format. In this article, I will discuss the main causes of #VALUE! and some possible solutions. The top 3 causes of #VALUE! [...]