I’d appreciate any help for the formula to calculate the following
benefit amount

To calculate the benefit amount take 55% of the first $3,500 of your
monthly earnings, add 40% of the balance of your month earnings up to a
maximum benefit amount of $3,500. Round benefit amount to the next
highest dollar.

For example

Monthly earnings $8,333.33
55% of first $3,500 = $1,925.00
40% of balance $4,833.33 = $1,933.33

Total $3,858.33 which should be rounded to $3858 and is also above the
maximum benefit amount so answer should show as $3,500

Thanks, Peter


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=394278