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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Also, I'm rounding one cell and putting the results into another. So I need
to round up G2 to the next .25 cents
 
Back
Top