Formula - Budgeting

[KD7410]

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.

 

[Shane Devenshire]

Hi,

suppose your drop down is in column B, amount in column A and your formula
in column C.

Create a factor table something like the following, say in F1:G5

Weekly 1
Monthly 4
Quarterly 13
Yearly 52
.....

Say your first row of data in row 2, then your formula would be

=A2/VLOOKUP(B2,F$1:G$5,2,False)

 

[KD7410]

Excellent!!! Thank you very much!!!!! Its been awhile since I've written
any formulas & I just couldn't work it out.