VSOR and VSAND functions

VSOR is the logic function where any of the given conditions must be fulfilled.

Below is the formula that counts the percentage of positive reception:

• =VSPER(VSOR("*R#", "*R+"))

This formula counts the percentage of positive reception in won sets:

• =VSPER(VSOR("*R+;WS-0","*R#;WS-0"))
  

VSAND is the logic function where all given conditions must be fulfilled.

Below is the formula that counts all side-out attacks in the first rotation:

• =VSCOUNT(VSAND("*A;*Z1", "*R;B-0"))

This formula counts the %kills in transition in lost sets:

• =VSPER(VSAND("*A#;LS-0","*R;B-0;NOT"))

You can use VSOR and VSAND functions in one formula. For example, here is the code that counts all aces that were served from zone one to zone one or nine by the player, whose number is in cell B5:

• =VSCOUNT(VSAND(VSOR(VSCELL("(1)S11#",Sheet1!$B$5), VSCELL("(1)S19#",Sheet1!$B$5))))
  

This formula counts the percentage of positive reception of serves that was played from zone one to zone one or nine after the 20th point:

• =VSPER(VSAND(VSCELL("(1)R#;PR20:*",Sheet1!$B$3),VSOR("aS11;P-1", "aS19;P-1")))

• =VSCOUNT(VSAND("*A",VSOR("*D#;B-0","*D+;B-0","*D!;B-0")))

• =VSCOUNT(VSOR("*D#","*D+","*D-","*D/"))