# Please, help me to find right formula

#### belimbor

##### New Member
 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?

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hi,

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

or without an IF

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

Last edited:
hi,

try this:

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

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

Replies
7
Views
480
Replies
3
Views
112
Replies
5
Views
96
Replies
6
Views
271
Replies
10
Views
105

1,207,391
Messages
6,078,215
Members
446,321
Latest member
thecachingyeti

### 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.

### Which adblocker are you using?

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

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