Using multiple responses.xls files possible? (case 437)

[friescamp]

Hmmm, I would not see how, but maybe you know? The problem is, that participants choose 1 out of 5 products each time, and each product has it's own price (and the price/product values are counterbalanced between conditions).

Thus, in responses.xls, I use the following formula as input for the counter of how much money people have left to spend:


=IF(B3=1;(B102-0,40);IF(B3=2;(B102-0,35);IF(B3=3;(B102-0,45);IF(B3=4;(B102-0,40);IF(B3=5;(B102-0,45))))))

Here, "B3" is the cell that collects participants response, and "B102" is the amount of money that was left after their previous choice.

Because in another condition the values that should be distracted are different (e.g., for choice 1 this should be 0,50 rather than 0,40), the entire formula becomes different, for example:

Condition 2:
=IF(B3=1;(B102-0,50);IF(B3=2;(B102-0,30);IF(B3=3;(B102-0,65);IF(B3=4;(B102-0,30);IF(B3=5;(B102-0,65))))))

If I follow your solution and enter "condition" as a variable in responses.xls (e.g., on position "B1"), I still do not see how I could use this to combine the above formulas (because the formulas already contain several IF...-rules). But all help is welcome of course!
Thank you for your help so far!

[jason_reed]

If you would upload a copy of your MediaLab files, I'd be happy to take a look at them.