Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |