How can I round UP to to the next ,50?

N

Nick Hodge

Vincent

Try this

=CEILING(A1,0.5)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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

Organizing a group of notebooks 0
Round up or down to $X.X9 or up to $X.X5 10
Easy one for you all... 6
Automation of scanned file storage based on content 0
Alternate Rounding Up & Down of .50 in a column 5
Formula to calculate differently based on original value 6
Rounding up or down to specific decimal digits. 2
Divide a # into 3 #'s rounded to a whole # 9

Top