Is there a shorter way of writing the following formula for calculating an
alimony deduction?

=IF(SUM(C11-C9)=C8,C8,IF(SUM(C11-C9)=0,SUM(C11-C9),0))

The formla calculates the alimony deductible (if any) on the 1040 return for
a given amount of total payments for alimony and child support per year.

The rules a
1) Payments are first allocated to child support (which is not deductible)
2) Any remaining payment is allocated to alimony, subject to a maximum
amount that is required in a decree of separation or divorce; that is, any
overpayments of alimony are also not deductible.

C8 is the required alimony payment per year
C9 is the required child support payment per year
C11 is the amount of actual total payments for a given year

To keep the formula from recording negative amounts, I had to insert two
additional "IF" operators. Is there a way to shorten the formula?




--
MZ