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")))