Formula if Colmns L,N & P = 0

ramco1917

New Member
Joined
Jun 21, 2016
Messages
16
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.


LMNOPQRST
00000000No
5447.62000000Yes
12678000000Yes
Thanks
 
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?
 
Upvote 0
T202502a.xlsm
X
1
2Yes
3No
4No
5
6d
Cell Formulas
RangeFormula
X2:X4X2=IF(MAP(L2:L4,N2:N4,P2:P4,SUM),"No","Yes")
Dynamic array formulas.
 
Upvote 0
Please ignore previous post; I reversed the requirement.

T202502a.xlsm
X
2No
3Yes
4Yes
6d
Cell Formulas
RangeFormula
X2:X4X2=IF(MAP(L2:L4,N2:N4,P2:P4,SUM),"Yes","No")
Dynamic array formulas.
 
Last edited:
Upvote 0
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
LNPTU
1
2000NoNo
3500YesYes
41200YesYes
523-5YesYes
Yes No 2
Cell Formulas
RangeFormula
U2:U5U2=IF(-MAP(L2:L5,N2:N5,P2:P5,CONCAT),"Yes","No")
T2:T5T2=IF(-(L2&N2&P2),"Yes","No")
Dynamic array formulas.
 
Upvote 0
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.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top