Thanks for looking in to this.
Thanks for looking in to this.
Hi cam15,
Just checking in to see if your study files are functioning as intended.
Jason Reed
Empirisoft Software Support Specialist
Hi Jason,
Yes they are, thank you. I believe there is an issue with using caps in the variable names that won't allow the responses to embed into subsequent questions. I'm not sure if it is using caps in the original variables names or in the new variables with the equations in the responses file, but I changed them to all lowercase letters and they are working now.
Thanks!
I'm glad to hear that everything is functioning. However, I'd be surprised if using capital letters was the cause of the problem. You should also be able to use capital letters in your variable names. If it's not too much trouble, could you tell me the what the old names of the problem variables were and what you changed them to?
Jason Reed
Empirisoft Software Support Specialist
I changed the original document I uploaded and can't seem to open it now, so I'm not completely sure about the old variable names, but I believe they were as follows:
OLD VARIABLE
multiple response question name = "DSM11a"
NEW VARIABLE
multiple response question name = "dsm11a"
In responses file, answer choices (these are the variables that include the =IF( , ) statements:
OLD VARIABLES NEW VARIABLES
DSM11a01opt dsm11a01
DSM11a02opt dsm11a02
DSM11a03opt dsm11a03
DSM11a04opt dsm11a04
DSM11a05opt dsm11a05
DSM11a06opt dsm11a06
DSM11a07opt dsm11a07
DSM11a08opt dsm11a08
If you are still able to open the files from my previous post, you can double-check what the old variable names were. I changed the variable names to lowercase letters and omitted the "opt" at the end to simplify.
Thanks for the information!
Jason Reed
Empirisoft Software Support Specialist
The moves toward Multiple data in one cell:
1. Open up your exercise manual.
2. Select the cell you need to put every one of your information.
3. Type = and select the main cell you wish to join.
4. Type and use quotes with space encased.
5. Select the other cell you need to join and hit enter. For instance =A3&" "&B3.