Round Whole Dollars Up to Five Dollars

Round Whole Dollars Up to Five Dollars

I have a column that takes a rate and decreases it by a discount percent:

=[List Rate]@row * (1 - ([Client Discount]@row + [Selected Discount]@row))

For Example

$ 300 less 15% discount = $ 255

$ 250 less 15% discount = $ 212.50

$ 90 less 15% discount = $ 76.50

I want to apply calculation that will result in rounding up to the nearest $5

For Example:

$ 300 less 15% discount = $ 255

$ 250 less 15% discount = $ 215 (instead of current value of $ 212.50)

$ 90 less 15% discount = $ 80 (instead of current value of $ 76.50)

Would appreciate any recommendations!

 

Tagged:

Comments

Sign In or Register to comment.