Excel tutorials

The Average Price of Gold and Silver

In this Excel Example Tutorial I will show how we can calculate how many months the price of gold is equal to or greater than the average value.

NOTE: The rates in the table are not realistic and do not reflect the real price of gold and silver have already been invented for examples of tutorials.

  • In 'A' column you notice names metals gold and silver as well as monthly changes in the value
  • In 'B:F' column you see the price of gold and silver during certain months
  • In 'G' column you notice the average price of silver and gold during the last 5 months
  • In 'H' column you notice the maximum value or the price of silver or gold during the last five months.

 

 The average price of gold and silver

The goal of this tutorial is to show how we can calculate the change in the prices of gold and silver in the last few months.

We can also calculate how many months the price of gold or price of silver was higher or the same than the average price of gold or silver during the last five months.

Calculation Prices of Gold and Silver

In Excel cells 'C4' and 'C5' is formula (copy it to the right):

=C2-B2

In cell 'G2' is the formula:

=AVERAGE(B2:F2) that has been copied down

In cell 'H2' is the formula:

=MAX(B2:F2) that has been copied down

In a cell, for example. 'J2' place the following formula:

=COUNTIF(B2:F2;">="&G2)

This formula returns a number '2' which means that the price of gold in the last five months was higher or equal to the average price of gold in only two months in the period of time over the past five months. The same formula applies to the price of silver is only copied down.