Solved: Round to the nearest quarter?

[debauch]

Hello,

I have a report that needs two decimal places, appropriately rounded to the nearest quarter (.25,.50,.75,.00)

Is this even possible? I have two conditions worked out :
=IF(SUM(AH3:AK3)=0,"",IF(RIGHT(ROUND(SUM(AH3:AK3),2),3)<RIGHT(0.25,3),ROUND(SUM(AH3:AK3),0)+0.25,
IF(RIGHT(ROUND(SUM(AH3:AK3),2),3)>=RIGHT(0.25,3),ROUND(SUM(AH3:AK3),0)+0.5,
IF(RIGHT(ROUND(SUM(AH3:AK3),2),3)<=RIGHT(0.5,3),ROUND(SUM(AH3:AK3),0)+0.75,"NO"))))

Is it possible to have 4 logic's in here?

[Bob Phillips]

Your formula confuses me, and errors in mys system, but to round to the nearest quarter, use

=ROUND(amt*4,0)/4

[debauch]

Wow. I was making a big mess. That helps a great deal!! It worked just fine. Thx XLD!!!!