Countif

J

Jeanette

I am trying to create a countif formula that meets the following criteria:

if <=0, 0
if >=1<=338, 1
if =339, 4
if >=340<=351, 1
if =352, 4
if >=353, 1

So far, I can only get a value of 1 to return for all criteria with the
following formula:
=+COUNT(IF(430<=0,0,IF(E430>=1<=338,1,IF(E430>=340<=351,1,IF(E430>353,1,IF(E430=339,4,IF(E430=352,4,0)))))))
 
R

RLA49

Hi,
Try this: =IF(A1=0,0,IF(OR(A1=339,A1=352),4,1))

Your formula did not evaluate any cell for the values you specifed. 'A1' is
the cell where the data is. This formula goes in a different cell.

RLA49
 
Top