if statement across range of cells

[beng986]

Hi,

I am trying to execute an if statement across a range of cells:

for instance I have

1,000	1,000	1,000
		1,000	1,000	1,000
				1,000	1,000	1,000
					1,000	1,000

For the top row I have the formula =if(AND(B1="",A1=1,000),"Yes","No"). Which works. But would I do the same thing across all the rows, but in one row. So I end up with:

No

No

No

Yes

No

Yes

N0

thanks in advance

 

[jasonb75]

What result are you expecting?

 

[beng986]

What result are you expecting?

The bottom line

No

No

No

Yes

No

Yes

No

 

[jasonb75]

Think this is right,

=IFERROR(IF(COUNTIFS(A1:A4,"",OFFSET(A1:A4,,-1),1000),"Yes","No"),"No")