formula if one of adacent cell contains value more than zero , return value

[Maklil]

Hello
I want populating value in adjacent cell in column F based on column C or D ,if one of columns C or D contains value bigger zero ,then should populate the value in adjacant value in column F ,otherwise should populate zero whether contains column C,D together zero or empty .

Maklil.xlsm
	A	B	C	D	E	F
1	ITEM	BRAND	PURCHASE	SALES	BALANCE	FORMULA
2	1	ref-air1000	11	0	110	11
3	2	ref-air1001	0	10	220	10
4	3	ref-air1002	0	0	300	0
5	4	ref-air1003	0	0	100	0
6	5	ref-air1004	11		110	11
7	6	ref-air1005			200	0
sheet1

thanks

 

[Peter_SSs]

Would this work for you? .. or does it need something different if both columns are > 0? (no sample like that was given)

22 09 25.xlsm
	C	D	E	F
1	PURCHASE	SALES	BALANCE	FORMULA
2	11	0	110	11
3	0	10	220	10
4	0	0	300	0
5	0	0	100	0
6	11		110	11
7			200	0
Maklil

Cell Formulas
Range	Formula
F2:F7	F2	=MAX(C2:D2)

 

[Maklil]

or does it need something different if both columns are > 0?

the most important gives the value bigger than zero , that's it .
impressive simple ! I thought needing multiple formuals overlapping each other
many thanks master .

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.