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
Bookmarks