Hello! I hsve this:

System.Math.Round((cdbl(sumT)+cdbl(sumN)+cdbl(sumI))*1.2,2)

And it will be: 45 673,552 - for example. Studio get me: 45 673,55 . But I need 45 673,56

I need also round up

Help me, please

Hello! I hsve this:

System.Math.Round((cdbl(sumT)+cdbl(sumN)+cdbl(sumI))*1.2,2)

And it will be: 45 673,552 - for example. Studio get me: 45 673,55 . But I need 45 673,56

I need also round up

Help me, please

Use `System.Math.Ceiling((cdbl(sumT)+cdbl(sumN)+cdbl(suml))*1.2, 2)`

.

I have this problem

Ah, there’s no parameter for decimal precision for the ceiling function.

Here’s a mathematical way of going about it: `System.Math.Ceiling((cdbl(sumT)+cdbl(sumN)+cdbl(suml))*1.2*100)*0.01`

.

This multiplies the value by 100, moving the decimal place over by 2, takes the ceiling, and then moves the decimal back into place.

1 Like

thank you so much

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.