Excel formula for rounding up or down when calculating superannuation to be full dollar value

Posted by Geoff Bestwick on September 30, 2001 11:14 PM

I need a formula to calculate superannuation to round up or down to the nearest dollar value.

So far the formula is this =sum(A30>450,(A30)*0.08)

help

Posted by Robb on October 01, 2001 3:51 AM

Geoff

Try:
=ROUND(sum(A30>450,(A30)*0.08),0)

Any help?

Regards

Posted by Aladin Akyurek on October 01, 2001 3:55 AM

I believe you want to round up or down the result of

=IF(A30>450,A30*0.08,0)

In order to round, you might want to use

=ROUND(IF(A30>450,A30*0.08,0)/0.5,0)*0.5

The alternative is

=MROUND(IF(A30>450,A30*0.08,0),0.5)

This requires Analysis Toolpak that you can add via Tools|Add-Ins.

I'd recommend using the ROUND formula.

Aladin

Posted by Aladin Akyurek on October 01, 2001 5:05 AM

Reconsidering...

If the formula

=sum(A30>450,(A30)*0.08)

is really meant as is, you should of course use it within ROUND or MROUND.

Aladin

=============