AnsweredAssumed Answered

URGENT!! Help On Rounding Numbers

Question asked by dekade on Feb 24, 2010
Latest reply on Feb 25, 2010 by mrvodka

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 

Outcomes