Please, help me to find right formula

[belimbor]

	F	G
6	0
7	0
8	460
9	460
10	-40
11	-70
12	-70
13	-70
14	-70	=IF(ISNA(MATCH($B$1;F6:F13;0));0;1))

<tbody>
</tbody>

Dear forum, I am trying to create formula when in the range F6:F13 there is number that is less than or equal to 0, then formula will get 0, and if there all numbers are above 0, need to get 1. There is 0 in B1. My above mentioned formula can only do this only if in a range is 0. Can someone help me?

 

[Mike LH]

Hi,

=IF(COUNTIF(F6:F14,"<=0"),0,1)

or without an IF


=--(NOT(COUNTIF(F6:F14,"<=0")>0))

 

[Michnia25]

hi,

try this:

=if(min(f6:f13)<=0,0,1)

 

[belimbor]

you are genius man, such a simple formula :D Thanks

 

[belimbor]

hi,

try this:

=if(min(f6:f13)<=0,0,1)

Thanks guys

 

[Michnia25]