Hello friends, good day to all. Today I want to ask you if there is any expression that can be rounded with conditions.
In Excel there is a formula called Rounding and that allows you to choose the number of decimal places and, not only that, but to decide if the rounding of the natural numbers is going to go from 5 to 5 or from 10 to 10.
The case is as follows:
I have an automatic price equal 3 x cost. often the cost is a decimal, say $547.31
The automatic price would be $1641.93
I would like to round this up to $1,650, however the CEILING([Price]) function returns $1,642
Does anyone know how to do it? Thanks since now.