Help!! How do you give a drop down a Math Value

[Guest]

I'm trying to create this chart to be able to automatically calculate total
income using a drop down cell.

COL C COL F COL G
Choose from Drop Down Stated Income = Total
Annually $50,000.00

COL A COL B
Annually 12
Semi Ouarterly 6
Quarterly 4
Bi-Weekly 2
Monthly 1

*Example: IF I select Annually from the drop down I want it to automatically
divided the "Stated Income" by 12. In other words my total will change
depending on what I select from the drop down. Any help would greatly be
appreciated it.

 

[Pete_UK]

If your drop-down is in C2, and you want the answer in G2, then try
this formula:

=F2/VLOOKUP(C2,A2:B6,2,0)

Hope this helps.

Pete

 

[mike.klein]

I'm trying to create this chart to be able to automatically calculate total
income using a drop down cell.

COL C COL F COL G
Choose from Drop Down Stated Income = Total
Annually $50,000.00

COL A COL B
Annually 12
Semi Ouarterly 6
Quarterly 4
Bi-Weekly 2
Monthly 1

*Example: IF I select Annually from the drop down I want it to automatically
divided the "Stated Income" by 12. In other words my total will change
depending on what I select from the drop down. Any help would greatly be
appreciated it.

A drop down selection will return a value representing where in the
range in the selection was made. For Example selecting Annually will
return a value of 1 or Quarterly a value of 3. (based on your list
above). What I have done in the past is to create a table
representing the values possible as a result of the corresponding drop
down box with another field being the values you stated above or
(1..12, 2...6, 3..4, etc). Then when you make your drop down box list
where you would like the value placed you can create a vlookup
referencing the 2nd column of the table you created. Your stated
income can then be your income divided by the result of you
vlookup....which of course is a result of your drop down box