ajBigNumShift function
Available for AlchemyJ Excel Library, AlchemyJ Enterprise Edition
Description
Returns a BigNumber whose value is the value of value shifted by the no. of places defined in places.
Syntax
ajBigNumShift(value, places)
Argument Name | Argument Type | Description |
---|---|---|
value (required) | String | A number in number or string format. For example, -1 or "-1". |
places (required) | Integer | It is a number value which is to define the no. of places to be shifted. If a decimal number is inputted, it will be rounded down. |
The function will return:
1) Return Value: BigNumber String
2) Return Type: Single Value
Example
=ajBigNumShift("12345678901234567.123",2)
The function returns "1234567890123456712.3".
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type. Besides, system will raise error for below scenario(s).
Error Scenario |
---|
Value is neither a number or a string that can be converted to a number. |
Places is neither a number or a string that can be converted to a number. |