drop down menu that multiplies a cell be a certain amount

[Leighton Durham]

hi im trying to make a sheet that will track my spending im trying to add a drop down menu that will multiply the inputted amount depending on its reoccurring rate for example i get payed X amount weekly so i will use the drop down menu to select weekly and it will multiply that amount accordingly any ideas of how i could do this?

 

[CsJHUN]

Hi Leighton

Is the below table is helping?
3 scenarios one for daily, one for weekly and one for monthly formulas, pick and edit as your desire

Munkafüzet1
	A	B	C	D	E	F	G	H	I	J	K
1		Item name	cost	dropdown	Value			multiply dropdown	Multiplicatior for days	Multiplicatior for weeks	Multiplicatior for months
2	Daily mult.	Blah 1	1	1/hour	24			1/hour	24	168	720
3		Blah 2	1	1/day	1			1/day	1	7	30
4		Blah 3	1	1/week	0,1428571			1/week	0,142857143	1	4
5	Weekly mult.	Blah 4	1	1/hour	168			1/ 2week	0,071428571	0,5	2
6		Blah 5	1	1/day	7			1/ month	0,033333333	0,033333333	1
7		Blah 6	10	1/week	1
8	monthly multip	Blah 7	10	1/hour	720
9		Blah 8	10	1/day	30
10		Blah 9	10	1/week	4
Munka1

Cell Formulas
Range	Formula
I2	I2	=24
J2	J2	=7*24
K2	K2	=30*24
I4	I4	=1/7
I5	I5	=1/7/2
I6:J6	I6	=1/30
E2:E4	E2	=VLOOKUP(D2,$H$2:$K$6,2,0)
E5:E7	E5	=VLOOKUP(D5,$H$2:$K$6,3,0)
E8:E10	E8	=VLOOKUP(D8,$H$2:$K$6,4,0)

Cells with Data Validation
Cell	Allow	Criteria
D2:D10	List	=$H$2:$H$6