Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!! How do you give a drop down 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
|
|||
|
|||
Help!! How do you give a drop down a Math Value
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!! How do you give a drop down a Math Value
On Nov 21, 11:56 am, 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. A drop down selection will return a value representing where in the range in the selection was made. For Example selecting Annually will return a value of 1 or Quarterly a value of 3. (based on your list above). What I have done in the past is to create a table representing the values possible as a result of the corresponding drop down box with another field being the values you stated above or (1..12, 2...6, 3..4, etc). Then when you make your drop down box list where you would like the value placed you can create a vlookup referencing the 2nd column of the table you created. Your stated income can then be your income divided by the result of you vlookup....which of course is a result of your drop down box |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help! How to give a drop down cell a math value? | Excel Discussion (Misc queries) | |||
math functions in a drop down menu? | Excel Discussion (Misc queries) | |||
Math help | Excel Discussion (Misc queries) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
math | Excel Worksheet Functions |