Formula if Colmns L,N & P = 0

[ramco1917]

Hi
I have data like below . I want formula If columns L , N And P = 0 then value in column T should be No else Yes.

L	M	N	O	P	Q	R	S	T
0	0	0	0	0	0	0	0	No
5	447.62	0	0	0	0	0	0	Yes
12	678	0	0	0	0	0	0	Yes

Thanks

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Can you have negative numbers in those cells?

 

[kvsrinivasamurthy]

In T2 copy down.

=If(and(L2=0,N2=0,P2=0),"No","Yes")

 

[kvsrinivasamurthy]

For 365 version. In T2, spill out formula.

=Map(L2:L4,N2:N4,P2:P4,lambda(x,y,z,If(and(x=0,y=0,z=0),"No","Yes")))

 

[Dave Patton]

T202502a.xlsm
	X
1
2	Yes
3	No
4	No
5
6d

Cell Formulas
Range	Formula
X2:X4	X2	=IF(MAP(L2:L4,N2:N4,P2:P4,SUM),"No","Yes")
Dynamic array formulas.

 

[Dave Patton]

Please ignore previous post; I reversed the requirement.

T202502a.xlsm
	X
2	No
3	Yes
4	Yes
6d

Cell Formulas
Range	Formula
X2:X4	X2	=IF(MAP(L2:L4,N2:N4,P2:P4,SUM),"Yes","No")
Dynamic array formulas.

 

[Peter_SSs]

Please ignore previous post; I reversed the requirement.

We do not know what is possible with the OP's data, but that latest formula would fail with 2,3,-5

My suggestions for 'copy down' and 'spill' (assumes all cells in the relevant columns contain a value)

25 02 23.xlsm
	L		N		P				T	U
1
2	0		0		0				No	No
3	5		0		0				Yes	Yes
4	12		0		0				Yes	Yes
5	2		3		-5				Yes	Yes
Yes No 2

Cell Formulas
Range	Formula
U2:U5	U2	=IF(-MAP(L2:L5,N2:N5,P2:P5,CONCAT),"Yes","No")
T2:T5	T2	=IF(-(L2&N2&P2),"Yes","No")
Dynamic array formulas.

 

[Dave Patton]

I like both of Peter_SSs' suggestions in post 7.

I did not read the initial question well enough and was just about to correct my post.