how do I write a formula to round up a number?

B

Barbie

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.
 
B

barbarellajk

Hi Jason,

Works great... You rock! You have saved us so much time and eliminated a
lot of angst.

Barbie & Andrea
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Formula help 2
adding a forumla to cells with formula in them already 1
Need formula to round number up to always end in X.X9 6
Divide a # into 3 #'s rounded to a whole # 9
Round up or down to $X.X9 or up to $X.X5 10
Finding the weighted average of text that have been given values 1
Round Function 5

Top