Roundup

R

rajgopal

I would like to roundup 1.23 to 1.25, 1.26 to 1.30, 1.28 to 1.30, 1.3
to 1.35 etc..

How can I use the roundup formula
 
D

Dave R.

ROUNDUP rounds based on how many decimal places you want, so it will change
the # of decimals if it's going to do any rounding. Since you want decimal
places the same before and after, try

=MROUND(A1,0.25)
 
D

Dave R.

That wont work sorry, try

=ROUNDUP(A1*2,1)/2




Dave R. said:
ROUNDUP rounds based on how many decimal places you want, so it will change
the # of decimals if it's going to do any rounding. Since you want decimal
places the same before and after, try

=MROUND(A1,0.25)
Click to expand...
 

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

Calculate end date and time 1
Location Oriented Formula 1
How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi 2
Searching the formula (not the value) for a text string 1
how do i use the roundup function 7
Nested Formulas v Named Formulas Any other solutions? 10
IF Formula problem 1
Nesting IF funtions 2

Top