Round up cdlb

Learn Academy Feedback
,
1

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

2

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

3

Безымянный

I have this problem

4

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
5

thank you so much

6

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