AppleWorks, AWGS
J
__________________________________________________________________
A Rounding Calculation for AppleWorks
__________________________________________________________________
Here's a calculation to take the product of two cells and round 
them up or down to the nearest $5.00 increment.

A2 is a number cell.

B2 is another number cell.

@IF(@MOD(A2*B2,5)<2.5,(A2*B2)-@MOD(A2*B2,5),A2*B2+(5-@MOD(A2*B2,5)
))

in AWGS it's:

= If(Mod(A2*B2,5)<2.5,(A2*B2)-Mod(A2*B2,5),A2*B2+(5-Mod(A2*B2,5)))