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
|