Signature (Visual Basic / VBA)
Public Function StepFn( _
ByVal vX As Variant _
) As Variant
Code Examples
StepFn(-1) = 0
StepFn(0) = 0.5
StepFn(1) = 1
StepFn(23) = 1
If X < 0: Return 0.
If X = 0: Return .5
If X > 0: Return 1.
Sgn(vX) / 2 + 1 / 2
Parameters
| Parameter | Description |
|---|---|
| vX | Number whose step (as defined above) is returned. Function returns Null if vX is Null or cannot be fixed up to a number. |
Notes & Version History
| v1.5 BugFix | Corrected this function to return 0 (zero) instead of -1 when vX is a negative number. |