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

On Nov 21, 5:56 pm, Silvastar
wrote:
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.