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