If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Write a Formula
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? |
#3
|
|||
|
|||
Write a Formula
"Esperanza" wrote:
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? If the account balance is in A1: =lookup(A1, {0,1000,5000},{0,100,200}) |
Thread Tools | |
Display Modes | |
|
|