Thread: Write a Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Esperanza Esperanza is offline
external usenet poster
 
Posts: 3
Default Write a Formula

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?