### Title

URGENT!! Help On Rounding Numbers

### Post

I have the following:

1 A field called "Finished Length"; It might currently have a number value of 13.0248

2 Then I have a field called "Rounded Off Finished Length"

3 If the right 5 digits of the "Finished Length" field are LESS THAN or EQUAL TO .3125 then the "Rounded Off Finished Length" will display 13

4 If the right 5 digits of the "Finished Length" field are GREATER THAN .3125 but LESS THAN or EQUAL to .5000 then the "Rounded Off Finished Length" will display 13.5

5 If the right 5 digits of the "Finished Length" field are GREATER THAN .5000 then the "Rounded Off Finished Length" will display 14

I cannot figure out the calculation for that for the "Rounded Off Finished Length" field.

Can someone help me write that calculation as soon as possible.

Thanks,

Dekade