Excel formula help
Solved/Closed
jgates
Posts
4
Registration date
Wednesday February 19, 2014
Status
Member
Last seen
February 19, 2014
-
Feb 19, 2014 at 02:01 PM
Blocked Profile - Feb 19, 2014 at 04:27 PM
Blocked Profile - Feb 19, 2014 at 04:27 PM
Related:
- Excel formula help
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets
4 responses
=IF(A1<>"",IF(AND(C2>=B2,B2>0),"Paid",IF(AND(A2<>"",B2>0),"Needs Paid","")),"")
Ok let us break down the nest:
first it:
=if(a1<>"", true, false)
*a1=true
**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)
Let me know if this gets closer!
Ok let us break down the nest:
first it:
=if(a1<>"", true, false)
*a1=true
**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)
Let me know if this gets closer!
jgates
Posts
4
Registration date
Wednesday February 19, 2014
Status
Member
Last seen
February 19, 2014
Feb 19, 2014 at 02:44 PM
Feb 19, 2014 at 02:44 PM
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.
A1 NAME
B1 AMOUNT OWED
C1 PAID AMOUNT
D1 STATUS
A1 = if blank, D1 needs to be blank
With your current formula, if A1 is blank, D1 shows "Paid".
=IF(C2=B2,"Paid",IF(AND(A2<>"",B2>0),"Needs 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.
Okay, I modified this a tad.. Let me give you the values and what it's doing.
A1 NAME
B1 AMOUNT OWED
C1 PAID AMOUNT
D1 STATUS
A1 = if blank, D1 needs to be blank
With your current formula, if A1 is blank, D1 shows "Paid".
=IF(C2=B2,"Paid",IF(AND(A2<>"",B2>0),"Needs 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.
jgates
Posts
4
Registration date
Wednesday February 19, 2014
Status
Member
Last seen
February 19, 2014
Feb 19, 2014 at 03:38 PM
Feb 19, 2014 at 03:38 PM
Here is a screenshot of what it's doing with no text in A2.
http://s28.postimg.org/car2rje59/paid.jpg
jgates
Posts
4
Registration date
Wednesday February 19, 2014
Status
Member
Last seen
February 19, 2014
Feb 19, 2014 at 04:07 PM
Feb 19, 2014 at 04:07 PM
You're BRILLIANT! +1 for your wonderful, dedicated help!
