| 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 | |||
Linear Mode
