Sage Peachtree quantum 2010 - 30 users

I am trying to create a payroll formula for a 401K loan payment. $23.91 will be the payment amount each paycheck and the loan limit is $3729.96. How do I set up the formula to stop the payment when the limit is reached?

My Bad!

~~I'm not quite sure what you are asking for.~~

~~Obviously a formula can't "stop" a payment.~~

~~If you are trying to keep track of the payments and watch the total amount owed decrease after each payment, you could do something like this:~~

~~1 - In A1 put 3729.96~~

2 - In A2 put =A1-23.91

3 - Move your cursor to the bottom right of A2 until it turns into a + sign

4 - Click and drag down to autofil the column with the formula.

~~When you reach A138, the remaining amount on the loan should be 3.29.~~

Hi DerbyDad03, I think that this is an accounting software issue, not Excel.

(Sage Peachtree Quantum 2010)

Regards

Ask Your Question

Weekly Poll

Do you think Google should sell budget phones in the US?

Discuss in The Lounge

Poll History