Let A1 hold the past due amount
=IF(A15000,200, IF(A1=1000,100,0))

OR
=(A1=1000)*100 + (A15000)*100

best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters


"Esperanza" wrote in message
...
How do I write a formula for penalty on past due accounts with great than
or
equal to 1000 but less than 5000, apply a penalty of $100.
For accounts with a past due balance of 5000 or more, apply a penalty of
200.
For accounts with a ttl past due balance of less than 1000, no penalty?