Signature (Visual Basic / VBA)
Public Function Chi( _
ByVal vA As Variant _
, ByVal vX As Variant _
, ByVal vB As Variant _
) As Variant
Code Examples
Chi(-5, 7, 10) = 1
Chi(-5, 10, 10) = .5
Chi(-5, 10, -20) = 0
A < X < B: Return 1
A = X or A = B: Return .5
X < A or X > B: Return 0
Parameters
| Parameter | Description |
|---|---|
| vA | The lower bound of the range against which vX is tested. Function returns Null if vA is Null or cannot be fixed up to a number. |
| vX | The number which is tested to see if it is within, on the bounds of, or outside the range from vA to vB. Function returns Null if vX is Null or cannot be fixed up to a number. |
| vB | The upper bound of the range against which vX is tested. Function returns Null if vB is Null or cannot be fixed up to a number. |
Notes & Version History
| v1.5 Note | The behavior of this function is undefined when A > B. |