Thanks but I don't think either of these work? Whenever I put in the formula, it gives the wrong price. For example, if I use the formula in B3, it gives a price of 1.533 but it should actually give 1.632 (cell K3).