Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to populate based on the dropdown selection..
I'm building a simple rev template, but I want it to be
multi-functional. Here's what I'd like it to do: INPUT SHEET: User is prompted to select task from a dropdown list (E3) . List has three options [Internal, Internal + Partner, Internal + Partner + Influencer] When user selects a particular option, a column on that INPUT SHEET (G3) automatically populates the sum of (D3*F3) How do I make this happen - and can I make this happen with those 3 option names? For reference, I would want the Type data to begin in Cell E3 of the Sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to populate based on the dropdown selection..
Try...
=IF(LEN($E3),$D3*$F3,"") ...which will leave the cell empty if E3 is blank! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Populate fields based upon dropdown selection | Excel Discussion (Misc queries) | |||
Populate one column based on the dropdown choice of others | Excel Discussion (Misc queries) | |||
Populate Sheet based on ComboBox selection | Excel Programming | |||
Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
Auto Populate Based on Other Selection | Excel Discussion (Misc queries) |