Hello Spencer,

Thanks for the speedy reply.

This portion of the budget is a continuing monthly event based on a (4) week to (5) week cycle. So I don't need it to divide the total due by any more than (5) weeks.

F16 represents the amount left to pay from the total.

Check out this example:

D16 = (-) $1,000 (total)
F16 = (-) $500 (left to pay)
C16 = (+) 5 (weeks till due)
E16 = (-) $100 (pay per week)

The extra condition "=if(f160=sum(d16/5))" comes in when F16 becomes a positive number. Once the total left to pay (F16) becomes a positive number, the number of weeks until the total is due (C16) becomes less important. The payments per week (E16) still needs to continue and be effective.

Like this example:

D16 = (-) $1,000 (total)
F16 = (+) $50 (left to pay)
C16 = (+) 2 (weeks till due)
E16 = (-) $200 (pay per week)

On a (-)$1,000 monthly total (D16) it's pointless for me to divide the total left to pay (F16) by the number of weeks until the total is due (C16) when (F16) is only (+)$50. The payments per week will be too small and will quickly end up back in deficit. So my solution is to divide the total due by the maximum number of weeks to pay (5) :

=if(f160=sum(d16/5))

This appears to me to be the best accounting solution for putting all the numbers in the plus. Unfortunately my knowledge of excel functions are limited. This is where I really need some help.

Thanks again.

Mark B