Spreadsheets have a quick recoding facility. Select Recode from the spreadsheet Vars toolbar button to display the Recode Values of Variable dialog. Scroll down in this dialog to define new values (text or numeric) of the current variable (see the groups New Value 1, New Value 2, New Value 3, etc., below) depending on the specific conditions defined (see the Category 1, Category 2, Category 3, etc., groups below).

For example, the recoding conditions specified above would "translate" the values less than or equal to 3 of the current variable (Quality) into Low, the values greater than 3 and less than or equal to 6 into Medium, and the values greater than 6 and less than or equal to 10 into High. Note that any other values that occur in the Quality variable would be "translated" into the missing data code because the MD Code option button is selected in the Other group box. Note also that STATISTICA first finds all cases that meet Category 1 and recodes them; then STATISTICA only searches through the remaining cases that have not been recoded to see if they meet Category 2, etc. Hence, it's not required to specify Quality > 3 AND Quality < = 6 in Category 2.

When specifying conditions, follow the standard syntax conventions common in STATISTICA to all those procedures that involve any operation of "selecting cases" based on their values.