Prorated repayment

August 24, 2011 at 13:39:24
Specs: Windows XP
A company has a standard repayment agreement for bonuses. If you exit within 12 months, you must repay 100%, 13-24 months you owe 50%, and 24 months +, you owe nothing.

Can someone help with an excel formula?

See More: Prorated repayment

August 24, 2011 at 14:45:33
You need to provide more information.

We don't know what data you have available to use for the calculation. A start date in one cell, an end date in another? The amount of the bonus in a 3rd cell?

Keep in mind that we can't see your spreadsheet from where we're sitting, so there's no point in trying to offer a solution that isn't going to work for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question