Hi,

I am trying to work out how to make a spreadhseet automatically calculate rates using two different data. please see the following:
Capture.JPG

In Column L I have a drop box stating new and old. So if I choose New I want a set of calculation to be done in Column M, using data from Column K and Q. Could someone please guide me on what function I need to be looking for. Your help will be much appreciated. Thanks