How do I round to the nearest $250

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

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

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