Payroll Formula

Sage Peachtree quantum 2010 - 30 users
December 10, 2009 at 20:29:19
Specs: Windows XP
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?

See More: Payroll Formula

Report •

December 11, 2009 at 09:19:29
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.

Report •

December 11, 2009 at 09:24:05
Hi DerbyDad03,

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

(Sage Peachtree Quantum 2010)


Report •

Related Solutions

Ask Question