I'm trying to figure out a formula but not having much luck. Three columns -
Amount $, Frequency (drop down list - weekly, mthly, qtr etc), Weekly. In
the Weekly column would like to write formula that would pick up Frequency
then divide Amount $ appropriately accordingly to what the drop down list
was. Ie Amount $ 40, Frequency Mthly = $10.