Rounding

[DaveInTexas]

Hey guys, first time here.
I am working with some formulae... they are pretty simple - its for using to figure out the FIT deductions to apply to my employees wages.
Anyway, I have the formulas just right except now I need to apply something to them in order that the final result is rounded up or down to the nearest even dollar.
Any ideas?

Here is a sample of one of the formulae:
=SUM(IF(E9<=51,0,IF(AND(E9>51,E9<=192),((E9-51)*0.1),IF(E9>192,14.1+(E9-192)*0.15))))

It will often result in a XX.59 result and I want XX.00

[Peo Sjoblom]

One way

=ROUND(SUM(IF(E9<=51,0,IF(AND(E9>51,E9<=192),((E9-51)*0.1),IF(E9>192,14.1+(E9-192)*0.15)))),)

rounds to nearest dollar. However you said even like in 2, 4, 6 etc?

=ROUND(SUM(IF(E9<=51,0,IF(AND(E9>51,E9<=192),((E9-51)*0.1),IF(E9>192,14.1+(E9-192)*0.15))))/2,)*2

--
Regards,

Peo Sjoblom

(No private emails please)


"DaveInTexas" <[email protected]>
wrote in message
news:[email protected]...
>
> Hey guys, first time here.
> I am working with some formulae... they are pretty simple - its for
> using to figure out the FIT deductions to apply to my employees wages.
> Anyway, I have the formulas just right except now I need to apply
> something to them in order that the final result is rounded up or down
> to the nearest even dollar.
> Any ideas?
>
> Here is a sample of one of the formulae:
> =SUM(IF(E9<=51,0,IF(AND(E9>51,E9<=192),((E9-51)*0.1),IF(E9>192,14.1+(E9-192)*0.15))))
>
> It will often result in a XX.59 result and I want XX.00
>
>
> --
> DaveInTexas
> ------------------------------------------------------------------------
> DaveInTexas's Profile:
> http://www.excelforum.com/member.php...o&userid=30212
> View this thread: http://www.excelforum.com/showthread...hreadid=498937
>

[DaveInTexas]

That did er, thanks pal!