Decimal to Floating point with ranges

[Eletrostatic]

Hi,

I am wanting to convert a Decimal value that needs to be scaled to a floating point value.

For example.

0 to 20000 Decimal value where half is considered the zero point. Then the values either side of this middle value are considered postivie or a negative double (0-10000 considered negative, 10001 to 20000 considered postive). Then the resolution of each decimal value is relative to a predefined scale.

Not sure how to go about this.

Any help is much appriciated.

[PaulieQ · Accepted solution]

Hi,

I hope I understood right what you wanted.

Please take a look in attachment.

Paulie

[Eletrostatic]

Works fine. Thanks