Filed under Formulas

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

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