Is conditional weighting possible?

[SPDempsey]

Does anyone know how to achieve conditional weighting? I want to do something similar to what I have pasted below.

For horses with X >= 0.01:
SUM_DIFF = 0.7 * X + 0.2 * Y + 0.1 * z
For horses with X between -0.01 and 0.01:
SUM_DIFF = 0.5 * X + 0.3 * Y + 0.2 * Z
For horses with X < -0.01 and Y >= 0.5:
SUM_DIFF = 0.3 * X + 0.6 * Y + 0.1 * Z

[Derek27]

Does anyone know how to achieve conditional weighting? I want to do something similar to what I have pasted below.

For horses with X >= 0.01:
SUM_DIFF = 0.7 * X + 0.2 * Y + 0.1 * z
For horses with X between -0.01 and 0.01:
SUM_DIFF = 0.5 * X + 0.3 * Y + 0.2 * Z
For horses with X < -0.01 and Y >= 0.5:
SUM_DIFF = 0.3 * X + 0.6 * Y + 0.1 * Z

That seems straightforward. Just have three rules, each with a condition to fire based upon the value of X. For each rule, set an SV for SUM_DIFF to the corresponding value.