ajBigNumShift function

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.