How VLOOKUP can get you in trouble and how to solve it

An updated version of this post has been published here: http://easy-excel.com/?p=683   An Extra Column Means Trouble If you want to find a value in a table in Excel, a simple VLOOKUP function is usually a good and easy way to do it. But you have to be careful – if you insert a new column … Continue reading →

The Easy Way to Calculate Grades in Excel

An updated version of this post has been published on my new site: http://easy-excel.com/?p=730   How can we calculate the grades (A-F) in Excel if we have the test results as numbers? We know that a score of 90% or higher is an A, 80-89% is a B, 70-79% is a C, 65-69% is a D … Continue reading →

Boolean logic in Excel: TRUE/FALSE instead of IF functions

A new version of this article has been published here: http://easy-excel.com/?p=638 Why use the IF function when there is an easier way to do it? If you’re looking for a TRUE or FALSE answer, you don’t need it! Let’s use Boolean logic instead – it will save you a lot of time and struggle. Let’s look at an … Continue reading →

Avoiding constants in Excel formulas

In this post I will show how important it is to avoid constants in a formula. In my example I have a list of products with purchase price in three different currencies. The question is, how should we go about calculating the price in US Dollars for each product? The first way (=D5*1,3045) will get … Continue reading →