Eric Carolus
Board Regular
- Joined
- Sep 17, 2012
- Messages
- 128
- Office Version
- 2016
- Platform
- Windows
Hi Folks
I have two columns, called Income and Expenses.
I wish to enter a value in only one cell in the same row.
I need some kind of mechanism to prevent the user from entering values in F5 AND J5.
Either by messagebox or simply clearing the two cells.
Thank you
Eric
I have two columns, called Income and Expenses.
I wish to enter a value in only one cell in the same row.
I need some kind of mechanism to prevent the user from entering values in F5 AND J5.
Either by messagebox or simply clearing the two cells.
Thank you
Eric
Chicken Braai _Saal_Kommitee.xlsm | |||
---|---|---|---|
F | |||
7 | |||
Other_expenses |
Chicken Braai _Saal_Kommitee.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | N | O | P | |||
2 | Income & Paid Prior Expenses | Balance after Steak Braai | |||||||||||||
3 | |||||||||||||||
4 | Income (Amount) | Individual/Person/Company | For | Date | Expense (Amount) | R431.20 | Current Balance (after expenses) | ||||||||
5 | 1 | R160.00 | Br. A. Carolus | Scrap (Chairs @ Hall) | 24-Jun-2021 | R591.20 | |||||||||
6 | 2 | Br. K. Paulse | Salary | 6-Jul-2021 | R150.00 | R441.20 | |||||||||
7 | 3 | ||||||||||||||
8 | 4 | ||||||||||||||
9 | 5 | ||||||||||||||
10 | 6 | ||||||||||||||
11 | 7 | ||||||||||||||
12 | 8 | ||||||||||||||
13 | 9 | ||||||||||||||
14 | 10 | ||||||||||||||
15 | 11 | ||||||||||||||
16 | 12 | ||||||||||||||
17 | 13 | ||||||||||||||
18 | 14 | ||||||||||||||
19 | 15 | ||||||||||||||
20 | 16 | ||||||||||||||
21 | 17 | ||||||||||||||
22 | 18 | ||||||||||||||
Other_expenses |
Cell Formulas | ||
---|---|---|
Range | Formula | |
L4 | L4 | =B4 |
N5 | N5 | =IF(AND(OR(F5=0,F5=""),J5>0), L4-J5,IF(F5>0,L4+F5,IF(OR(J5=0,J5=""),L4,IF(J5>0,L4-J5)))) |
N6:N22 | N6 | =IF(AND(OR(F6=0,F6=""),OR(J6=0,J6="")),"",IF(AND(OR(F6=0,F6=""),J6>0),N5-J6,IF(AND(OR(J6=0,J6=""),F6>0),N5+F6))) |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
G5:G22 | List | =SteakNames |