How would I round UP to the NEXT .25 cents.

[Guest]

How would I round UP to the NEXT .25 cents. ie I would like 1.01 to be 1.25,
1.32 to be 1.50, 1.51 to be 1.75 and 1.76 to be 2.00. What formula would I
use in Excel to accomplish this?

 

[NHarkawat]

=ceiling(a1,0.25)

 

[firefytr]

Hello,

Check out the CEILING function for this ...

=CEILING(A1,0.25

 

[Guest]

Also, I'm rounding one cell and putting the results into another. So I need
to round up G2 to the next .25 cents

 

[CarlosAntenna]

=CEILING(A1,0.25)

 

[Frank Kabel]

Hi
also see:
http://www.xldynamic.com/source/xld.Rounding.html

 

[Guest]

Thank you so much....!!!! This works like a charm

 

[firefytr]

So ...

=CEILING(G2,0.25