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]...

 

[DaveInTexas]

That did er, thanks pal