Ok let us break down the nest:
=if(a1<>"", true, false)
**IF(AND(C2>=B2,B2>0),"Paid" This is where the code can start getting messy, and it is all logic related. If you understand the nested logic, then modify to your own specifications. In the above example, c2 has to be equal or greater than b2, AND B2 has to be greater than 0 to satisfy the true (displays PAID)
No, not homework my friend. I am a marketing coordinator for a communications company looking for a easier way to track my reps money logs.
Okay, I modified this a tad.. Let me give you the values and what it's doing.
B1 AMOUNT OWED
C1 PAID AMOUNT
A1 = if blank, D1 needs to be blank
With your current formula, if A1 is blank, D1 shows "Paid".
(you used row 2, but it's all the same for what I need to do)
I need to check also that if A1 has a name (text) that it does a check to see if C1 is equal to B1. If C1 is NOT equal (total owed is paid), then D1 needs to state "Needs Paid" but if it's fully paid (B1 and C1 are equal), D1 states "Paid".
I have really confused myself so I took a breather.