# Spreadsheet Formulas - Examples

The following table illustrates examples of Statistica spreadsheet formulas:

 Formula Result =(Measur1+Measur2+Measur3)/3 This formula will compute the average of three variables. =(v0<=10)*1+(v0>10)*2 This formula will recode cases 1-10 as 1, and the rest as 2. Note that a logical expression evaluates to 1 if it is true and to 0 if it is false. =((v1=1) AND (v2=5))*5 This formula returns the value of 5 if v1=1 and v2=5, and 0 otherwise. Note that a logical expression evaluates to 1 if it is true and to 0 if it is false. =(((v1=1)OR(v2=5))<>0)*5 This formula returns the value of 5 if either or both conditions hold, and 0 otherwise. Note that a logical expression evaluates to 1 if it is true and to 0 if it is false. =student(v4,15) This formula returns probability density values of the Student's t distribution based on the values of v4 and 15 degrees of freedom. =trunc((v0-1)/10) This formula assigns consecutive integers to the consecutive sets of 10 cases (i.e., cases number 1 through 10 will be assigned 0, cases number 11-20 will be assigned 1, and so on. =(V1 - VARMEAN(V1))/VARSTDDEV(V1) This formula returns the normalized values for variable 1.