debauch
12-10-2007, 03:26 PM
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?
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?