Rouding up the last 5' digit: Leaner solution than mine?

Questions about MultiCharts and user contributed studies.
arjfca
Posts: 1273
Joined: 23 Nov 2010
Has thanked: 721 times
Been thanked: 222 times

Rouding up the last 5' digit: Leaner solution than mine?

Postby arjfca » 11 Aug 2011

Hello

I want to round up the least significant digit of a price.
EX: 1.42345 = 1.4235

Actualy i do
Value1 = Number * 10 000 1.42345 = 14234.5
Value1 = Ceiling (value1) = 14235
Value1 = Value1 / 10 000 = 1.4235

Is there a leaner solution?

Martin

User avatar
Dave Masalov
Posts: 1712
Joined: 16 Apr 2010
Has thanked: 51 times
Been thanked: 485 times

Re: Rouding up the last 5' digit: Leaner solution than mine?

Postby Dave Masalov » 11 Aug 2011

Martin,

You can use the following keyword:

Code: Select all

round(number, 4)
These users thanked the author Dave Masalov for the post:
arjfca


Return to “MultiCharts”