 ShowAll Questionssorted byDate Posted Natraj

# Rounding a number

Hi All,

I need to round numbers similar to the example below.

5.2 should be rounded to 5

5.3 to 5.7 should be rounded to 5.5

Greater than 5.7 to 6.

Is there any formula function or known way to do this?

Help me in this.

Thanks !! imutsav
I don't think what you are trying would be exactly possible. But still the below link would help you get more information. It has all the methods available to round off.

http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_methods_system_decimal.htm

Thanks
Utsav

[Do mark this answer as solution if it works for you and give a kudos.] Shannon Hale

The only thing I can think of that would allow you to do this in a formula field would be something like this:

```IF (
Number__c - FLOOR( Number__c ) < 0.2,
FLOOR( Number__c ),
IF (
Number__c - FLOOR( Number__c ) > 0.7,
CEILING( Number__c ),
FLOOR( Number__c ) + 0.5
)
)```

Subtracting FLOOR( Number__c ) from the number gives you the decimal value.

If the decimal value is less than 0.2, return FLOOR( Number__c ) -- rounding down.

If the decimal value is greater than 0.7, return CEILING( Number__c ) -- rounding up.

Otherwise, returning FLOOR( Number__c ) + 0.5 gives you N.5.