Not sure if this resolves everything, but, try putting SILVER in quotes so it reads =IF(G14="SILVER".... It also looks like you might be missing a ) at the end of the formula.