Round Whole Dollars Up to Five Dollars

TerrieVent

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!

 

p_bureau

Hi !

 

You could use something like "=ROUNDUP(Start_Value / 5, 0) * 5"

 

Does this help?

 

Paul.