danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Invoice | Approved | Payment Date | ||
2 | 1 | 500 | 01/01/19 | ||
3 | 1 | 500 | 01/01/19 | ||
4 | 1 | ||||
5 | 1 | ||||
6 | 2 | 501 | |||
7 | 2 | 501 | |||
8 | 2 | ||||
9 | 2 | ||||
10 | 3 | ||||
11 | 3 | ||||
12 | |||||
13 | |||||
14 | Invoice | Status | |||
15 | 1 | Paid | |||
16 | 2 | Approved | |||
17 | 3 | Not Approved | |||
Sheet3 |
Hello guys,
I have a sheet with invoice information which can be categorized as either:
- Approved = there is a value in Column B but not in Column C
- Paid = there is a value in Column C
- Not Approved= there are no values in Column C AND Column B
B15:B17 is the output I am looking for.
How would you go about creating a formula to show this output?
Invoice 1:
Rows 4-5 represent the booking of invoice 1
Rows 2-3 show that invoice 1 has been paid since there is a date in Column C
FWIW
If an invoice has been paid, as in the case of invoice 1, I don't need to know whether it has been approved or not.
Thank you