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

G

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.
 

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

Similar Threads

Help!! How do you give a drop down a Math Value 2
math functions in a drop down menu? 1
How to write a macro 4
I need the cell to prompt me... 2
How to make items in a drop down menu reference a number 2
Formatting Text for Drop Down-HELP! 4
automatically selecting items in drop down list 5
How to delete a drop down box in Excel 2007 1

Top