1 2 Previous Next 17 Replies Latest reply on Apr 15, 2016 6:34 AM by DemersGlass

    Looking for a calculation or script to round up to the next even integer

    DemersGlass

      Hi,  Using Filemaker Pro 14 -  I am working with an established set of records, trying to add in an estimating page.  I'm stuck now getting our measurements (window glass) to round up to the next even integer to calculate the cost by total square feet..

       

      For instance the measurements of a window would be 47.5" x 39.75" .  Our cost and customer pricing is charged by the even inches so we would base our charge on 48" x 40".  In Excel, I found a function to do this calculation, and found a custom function for Filemaker Pro Advanced, but so far am unable to determine a calculation or script that isn't quite cumbersome and prone to errors to do this.

       

      Can anyone help me with this?

       

      Barbara

        1 2 Previous Next