Round up formula field to nearest 5000

Question

I have two fields (Volume & Price) that are then being calculated by a formula field to determine a Credit Limit (just a simple Volume * Price formula). The credit manager would now like the Credit Limit field to be rounded up to the nearest $5000. So if the Credit Limit is calculated at $8250.00, he would like the field to read $10000. Is this possible with the ROUND function? Any help would be greatly appreciated!

Steve Molis · Accepted Answer

So something kinda like this?   Datatype = Formula   Result = Currency   Formula =  ROUND( ( Quantity__c * Price__c ) / 5000 , 0 ) * 5000

Ahilesh Ragavan Radhakrishnan · Answer

Are you looking for this ?? FLOOR(Credit_Limit__c/5000)*5000 + IF(MOD(Credit_Limit__c,5000)< 2500, 0, 5000)

Round up formula field to nearest 5000

Data Management

相关学习

更多帮助