Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell reference math | Excel Discussion (Misc queries) | |||
math functions in a drop down menu? | Excel Discussion (Misc queries) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
CELL REFERENCE MATH | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |