how do I round a column of numbers to the nearest

S

Suzy

How do I round a column of numbers up or down? ei. $27.51 = $27.50 and
$29.24 = $29.25?
 
S

Shane Devenshire

Hi,

Depending on exactly what you mean,
Look at each of these:
ROUNDUP(X,2)
CEILING(X,2)

MROUND(27.51,.50) rounds to the nearest 50 cents.

If this helps, please click the Yes button,

Cheers,
Shane Devenshire
 
T

T. Valko

It looks like you want to round to the nearest quarter.

If you have the Analysis ToolPak add-in installed (versions of Excel prior
to Excel 2007):

=MROUND(A1,0.25)
 

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

Divide a # into 3 #'s rounded to a whole # 9
Setting column width in a table with a macro is not working 0
Round numbers to get to the nearest 0.09 7
rounding up to the nearest 1000 1
Alternate Rounding Up & Down of .50 in a column 5
rounding a number up to a certain ending digit 6
How to count the numbers in a Word document? 0
Rounding Time to Nearest 5 Minutes 1

Top