Signature (Visual Basic / VBA)
Public Function NextNumber( _
ByVal vX As Variant _
, Optional ByVal vPrecision As Variant _
, Optional ByVal vOffset As Variant _
) As Variant
Code Example
NextNumber(0, 2, 1) = 1
NextNumber(1, 2, 1) = 3
NextNumber(2, 2, 1) = 3
NextNumber(22.4, 2, 1) = 23
NextNumber(-1.7) = -1
NextNumber(-6.5) = -6
NextNumber(-7.8) = -7
Parameters
| Parameter | Description |
|---|---|
| vX | Number which is rounded-up to the next number. Function returns Null if vX is Null or cannot be fixed up to a number. |
| vPrecision | The precision used when rounding vNumber. vPrecision defaults to 1 (one) if it is missing or Null or cannot be fixed up to a number. With a precision of 1 (one), function returns the smallest integer greater than vNumber. |
| vOffset | The starting number in the sequence to which vX is rounded up. vOffset defaults to 0 (zero) if it is missing or Null or cannot be fixed up to a number. With a precision of 2 and an offset of 0, function returns the next even number. With a precision of 2 and an offset of 1, function returns the next odd number. |
Notes & Version History
| Note | Similar to calling the Ceiling function except that if vX is already at the ceiling, this function returns the next ceiling. |