rounding decimals to nearest quarter

A

ajeuck

How do I round a dollar amount to the nearest .25

i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....
 
T

T. Valko

Try one of these:

Requires the Analysis ToolPak add-in be installed for Excel versions prior
to Excel 2007:

=MROUND(A1,0.25)

This one will work in any version:

=ROUND(A1/0.25,0)*0.25
 
A

ajeuck

Fabulous!!! Thank you!
Is there a way to set parameters?
i.e if less than .12 round down more than .12 round up?
 

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
rounding numbers to the nearest dollar amount 11
Mail Merge Switch - Dollars to Words 0
combo function of adding % 2
rounding up to the nearest 1000 1
Divide a # into 3 #'s rounded to a whole # 9
Decimals Constant to 0.50 or Nearest Integer 3
ROUNDING NUMBERS 3

Top