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

S

Silvastar

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.
 
P

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top