I'm working on a bond valuation calculator and I want my present value to depend on a compounding method chosen from a drop down list (i.e. annual, semi annual, quarterly, monthly). When a different compounding method is chosen, my rate needs to change accordingly (semi-annual would be rate/2, quarterly would be rate/4 etc.) but I do not want the value to change in the Rate cell, only be reflected in the PV calculation. IS this a matter of nesting IF functions within the rate in my PV function? Or should I associate each option in the dropdown with a number value?