Can anyone please help me with a formula. As in the example I have people who pay monthy or
in full. If they pay in full they get a 10% discount. So in the PAID IN FULL cell enter
the full amount, in the DISCOUNT cell it will give the full amount - discount. DUES PAID
will give give either the value from PAID IN FULL or the total of SEPT-OCT-NOV-DEC. The
ARREARS will give the amount unpaid.

SEPT OCT NOV DEC "PAID
IN FULL" DISCOUNT DUES PAID ARREARS
0       0       0       0        2400           240             2160            0  
242     242     242     242      0              0               968             0
224     224     0       0        0              0               448             448

What I am trying to do in the DUES PAID is something like
=if(Paid in full>0,Paid in Full - 10%,) if(Paid in full<1,total of SEPT-OCT-NOV-DEC) then give the ARREARS.
Regards Mike

---

Reply from Alex Hedley:

Depending on the Column
=If($e1 > 0, if($e1 > 0), $e1*90%, $a1+$b1+$c1+$d1), 0)