Round Whole Dollars Up to Five Dollars

TerrieVent
edited 12/09/19 in Formulas and Functions

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!

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!