You are here:
ROUND
Returns the nearest number to a number you specify, constraining the new number by a specified number of digits.
Use
ROUND(number,
num_digits) and replace number with the field or
expression you want rounded; replace num_digits with the number of decimal
places you want to consider when rounding.
Example
ROUND (1.5, 0) = 2
ROUND (1.2345, 0) = 1
ROUND (-1.5, 0) = -2
ROUND (225.49823, 2) = 225.50
Simple Discounting Example
ROUND(Amount-Amount* Discount_Percent__c,2)
Use this formula to calculate the discounted amount of an opportunity rounded off to two digits. This example is a number formula field on opportunities that uses a custom percent field called Discount Percent.
Did this article solve your issue?
Let us know so we can improve!
