CEILING(1.19) = 2
FLOOR(1.19) = 1
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 15, 2016 11:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: Calculated Field Rounding up
A trick to "round up" when a system just truncates, is to add 0.5 to the result.
70 / 36 + 0.5 = 2.44 , wich truncates to 2.0
This is an old trick from assembly language programming days (pre - floating point math)
Calvin
Disclaimer
The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.