Hi All,
Trying to speed up checking through data by using a single formula if possible, happy to do via macro also if easier.
I have a set of data which contains scores for a participant over 5 different activities.
I then have a comment column at the end, in which i would like the formula to tell me whether the participant has passed if the cells are above 50 or blank and failed if any of the cells are less than 50 and contain a number, i.e. 0.
Pass for each activity is either above 50 or blank cell (no data)
Fail for each activity is between 0 and 49
See attached data set for example to work with.
Thanks in advance.
Bookmarks