Always Round Up

[Guest Yukon Cornelous]

Whether it is 90.1 or 90.9 , I want to always roundup.

But if 90.0 leave it alone

Any Ideas?

[diesoft]

Code:

---

Case( 
  Mod(yourNumber, 1),  
  Int(yourNumber) + 1
)  

---

Should do the job. Although the following may be more explicit when looking at it later, but the extra syntax is not needed:

Code:

---

Case( 
  Mod(yourNumber, 1) > 0,  
  Int(yourNumber) + 1,
  yourNumber
)  

---

[comment]

Int( InputNumber) + (Mod(InputNumber, 1) > 0)

[Guest Yukon Cornelous]

Thanks Comment

 

works good.