Need help! How to give a drop down cell a math value?
 

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.

Need help! How to give a drop down cell a math value?
 

Please don't multi-post - see your other post for an answer.

Pete

On Nov 21, 5:44 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.