Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Answers to questions posing more questions in a workbook
I am trying to write a manual whereby I pose a question to the user.
Depending on what they answer, another question would appear: Like "Are you issuing a credit for an entire order?" If YES, then ask "Is it before or after inventory?" and so on. I KNOW I have done this in Excel many years ago but I cannot for the life of me remember how I did it. Does anyone know wht I am talking about? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Answers to questions posing more questions in a workbook
On Aug 7, 12:24*pm, sbelle1 wrote:
I am trying to write a manual whereby I pose a question to the user. Depending on what they answer, another question would appear: Like "Are you issuing a credit for an entire order?" If YES, then ask "Is it before or after inventory?" and so on. I KNOW I have done this in Excel many years ago but I cannot for the life of me remember how I did it. Does anyone know wht I am talking about? Write IF statements...so if the answer is YES...where you want the next question to pop up, write =IF($A$3="YES","Is it before or after inventory?",IF($A$3="NO","Insert your question that would return if the user put NO",0)) Is that what you are looking for? This way, you will have to manually type in formulas for the following questions. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Answers to questions posing more questions in a workbook
See Debra Dalgleish's site for creating dependent data validation dropdowns.
May do what you want. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Fri, 7 Aug 2009 09:24:01 -0700, sbelle1 wrote: I am trying to write a manual whereby I pose a question to the user. Depending on what they answer, another question would appear: Like "Are you issuing a credit for an entire order?" If YES, then ask "Is it before or after inventory?" and so on. I KNOW I have done this in Excel many years ago but I cannot for the life of me remember how I did it. Does anyone know wht I am talking about? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seeing only answers in Google group -- no questions | Excel Worksheet Functions | |||
Links to Answers to questions | Excel Discussion (Misc queries) | |||
create list for questions/answers | Excel Discussion (Misc queries) | |||
Customizing help questions/answers | Excel Discussion (Misc queries) | |||
Saving Posts Questions & Answers In My Computer | Excel Discussion (Misc queries) |