Rounding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DaveInTexas - 07 Jan 2006 04:42 GMT

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

Signature

DaveInTexas

Reply to this Message

Peo Sjoblom - 07 Jan 2006 05:07 GMT

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

Signature

Regards,

Peo Sjoblom

(No private emails please)

> Hey guys, first time here.
> I am working with some formulae... they are pretty simple - its for
[quoted text clipped - 8 lines]
>
> It will often result in a XX.59 result and I want XX.00

Reply to this Message

DaveInTexas - 07 Jan 2006 15:31 GMT

That did er, thanks pal

Reply to this Message