View Single Post
  #1   Report Post  
Barbie
 
Posts: n/a
Default how do I write a formula to round up a number?

I want to write a formula that will allow me to multiply a currency number by
9 and then round the number up so that it ends in 9. For example, $56.50 x 9
= $508.50 and then round it up to be $509 (no decimals needed). Thanks so
much for your help.