8 Replies Latest reply on Jun 5, 2017 12:12 PM by JMMurphy181

    Help with rounding writing a function for rounding down.

    JMMurphy181

      I need some help creating a formula for rounding down a field in a form I'm creating.  I need the field to take the numbers from 2 separate fields and add them together subtract 10 and then divide by 2.

       

      Something like (Field1+Field2-10)/2  and then round down to the nearest whole number so 4.5 goes to 4 and so on.

       

      Also I dont know if it would work differently but if it does i need it to work with negative numbers so -3.5 rounds to 4

       

      If anyone could help me with this i would be very appreciative.