How to return a complete or incomplete dataset with Blanks

[sinkin]

I have a data set for which 4 columns have a score of 0 - 29.
I want to create a column which tells me that each column with a score in has been input correctly.

I want to return an answer of 1 (complete and within range of 0-29) or 0 (incomplete or mistyped e.g.210).

I have tried isblank and =IF(AND(a<=29 etc
the issue is that Excel seems to calculate a blank cell as a 0 figure which means that an incomplete column is recorded as complete as 0 is , 29

Any help greatly appreciated

 

[Aladin Akyurek]

Is this what you are after?

In E2 enter and copy down:

=IF(COUNTIFS(A2:D2,">=0",A2:D2,"<=29")=4,"","in")&"correct"<strike></strike>