ADD a value to only one of two cells in the same row, but not both

[Eric Carolus]

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

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

 

[Fluff]

You can use data validation for that, select Custom & use

=J5=""

for F5

 

[Eric Carolus]

Hi Fluff
Thanks for the reply.

I have done what you indicated.
Selected F5, Data validation, Custom and then typed =J5="" (in F5).
Yet both values remain in F5 and J5 (I entered a value here in J5)
Yet nothing happens.

Did I get wrong?
Please advise.

Thanks

 

[Fluff]

Should have said you need to do the same for J5 looking at F5.

 

[Eric Carolus]

Should have said you need to do the same for J5 looking at F5.

Hi Fluff
Thanks, It works like a charm.
Eric.

 

[Fluff]

You're welcome & thanks for the feedback.