How do I round to the nearest $250

Dedrie · Aug 10, 2005

I'm working on life insurance policy calculations and the policies are 4 time
annual salary to the nearest $250. Is there a formula I can use to do the
calculation?

So someone with $43,300 annual salary would get $173,250 in benefit - 43,000
* 4 = $173,200 neareast $250 is $173,250.

Thanks!
Dedrie

aristotle · Aug 10, 2005

Hi,

You can use the MROUND() function within the morefunc addin to do this:
http://xcell05.free.fr/english/
Use this link to download the add-in.

Regards,
A

Dedrie · Aug 10, 2005

I downloaded, but I'm still not sure what to do.

aristotle said:
Hi,

You can use the MROUND() function within the morefunc addin to do this:
http://xcell05.free.fr/english/
Use this link to download the add-in.

Regards,
A

Ron Coderre · Aug 10, 2005

Try this:

=ROUND((A1*4)/250,0)*250

If A1=43300 the return is 173250.

Does that help?

Dedrie · Aug 10, 2005

Yes thank you that worked!

Ron Coderre said:
Try this:

=ROUND((A1*4)/250,0)*250

If A1=43300 the return is 173250.

Does that help?