ROUND values

Hello everyone! 

We have a list of prices and we want to round the prices and apply specific rules to the intervals.

If price finishes with numbers in interval of 0-2,5, the price has to be rounded to 0
If price finishes with numbers in interval of 2,5-7 then it has to be rounded to 5
If price finishes with numbers in interval of 7,01-9,99 it has to be rounded to 0 (bigger value)

Thank youuu!!!

By: Tim

Leave a Reply

Your email address will not be published. Required fields are marked *