Formula - Budgeting
 

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.

Formula - Budgeting
 

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)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"KD7410" wrote:

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.

Formula - Budgeting
 

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

"Shane Devenshire" wrote:

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)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"KD7410" wrote:

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.