Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is It Possible to create a form/survey in Excel to analise info
Hello
My manager wants me to create a Customer satisfation survey (with all the tick boxes etc - like how satisfied are you out of 1 to 10 and they select either 1,2,3...) He wants it done in excel so we can then use If statements to look up an rate the answer, liek if they select 5 then paste here and add 10 or something silly,, Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is It Possible to create a form/survey in Excel to analise info
Hi Rachie,
Are you thinking to send out the excel file for the customer to fill it out or you will be entering the information in the spreadsheet "Rachie1987" wrote: Hello My manager wants me to create a Customer satisfation survey (with all the tick boxes etc - like how satisfied are you out of 1 to 10 and they select either 1,2,3...) He wants it done in excel so we can then use If statements to look up an rate the answer, liek if they select 5 then paste here and add 10 or something silly,, Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is It Possible to create a form/survey in Excel to analise inf
Hi Eduardo,
I think it will be sent out on an excel file for the customers to fill out, and then he wants to analyse that from the excel file but i dont think its possible for excel to pick up if an option button or check box is selected? "Eduardo" wrote: Hi Rachie, Are you thinking to send out the excel file for the customer to fill it out or you will be entering the information in the spreadsheet "Rachie1987" wrote: Hello My manager wants me to create a Customer satisfation survey (with all the tick boxes etc - like how satisfied are you out of 1 to 10 and they select either 1,2,3...) He wants it done in excel so we can then use If statements to look up an rate the answer, liek if they select 5 then paste here and add 10 or something silly,, Is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is It Possible to create a form/survey in Excel to analise inf
Hi Rachie,
Debra has very useful information in her web, I think this is what you are looking for http://contextures.com/xlUserForm01.html "Rachie1987" wrote: Hi Eduardo, I think it will be sent out on an excel file for the customers to fill out, and then he wants to analyse that from the excel file but i dont think its possible for excel to pick up if an option button or check box is selected? "Eduardo" wrote: Hi Rachie, Are you thinking to send out the excel file for the customer to fill it out or you will be entering the information in the spreadsheet "Rachie1987" wrote: Hello My manager wants me to create a Customer satisfation survey (with all the tick boxes etc - like how satisfied are you out of 1 to 10 and they select either 1,2,3...) He wants it done in excel so we can then use If statements to look up an rate the answer, liek if they select 5 then paste here and add 10 or something silly,, Is this possible? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is It Possible to create a form/survey in Excel to analise inf
Hi Rachei, here is a better link and it is for a Survey form
http://www.contextures.com/xlform01.html "Rachie1987" wrote: Hi Eduardo, I think it will be sent out on an excel file for the customers to fill out, and then he wants to analyse that from the excel file but i dont think its possible for excel to pick up if an option button or check box is selected? "Eduardo" wrote: Hi Rachie, Are you thinking to send out the excel file for the customer to fill it out or you will be entering the information in the spreadsheet "Rachie1987" wrote: Hello My manager wants me to create a Customer satisfation survey (with all the tick boxes etc - like how satisfied are you out of 1 to 10 and they select either 1,2,3...) He wants it done in excel so we can then use If statements to look up an rate the answer, liek if they select 5 then paste here and add 10 or something silly,, Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a survey using excel? | New Users to Excel | |||
How can one set up a survey form in Excel | New Users to Excel | |||
Can one set up a survey form on excel? | New Users to Excel | |||
Create form that can't be chg'd but info can be copied/pasted? | Excel Discussion (Misc queries) | |||
Can I create a form to run off of info saved on Excel 97? | Charts and Charting in Excel |