How do I round to the nearest $250
 

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

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" wrote:

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

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

"aristotle" wrote:

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" wrote:

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

Try this:

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

If A1=43300 the return is 173250.

Does that help?
--
Regards,
Ron


"Dedrie" wrote:

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

Yes thank you that worked!

"Ron Coderre" wrote:

Try this:

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

If A1=43300 the return is 173250.

Does that help?
--
Regards,
Ron


"Dedrie" wrote:

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