How do I round to the nearest $250

[Guest]

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

 

[Guest]

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

 

[Guest]

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

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

 

[Guest]

Try this:

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

If A1=43300 the return is 173250.

Does that help?

 

[Guest]

Yes thank you that worked!

Try this:

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

If A1=43300 the return is 173250.

Does that help?