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
to 1.35 etc..
How can I use the roundup formula
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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)
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
=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)
R
rajgopal
It worked. Thanks a lo
P
Peo Sjoblom
This would be a little bit more effective
=CEILING(A1,0.05)
--
Regards,
Peo Sjoblom
=CEILING(A1,0.05)
--
Regards,
Peo Sjoblom
Dave R. said:That wont work sorry, try
=ROUNDUP(A1*2,1)/2