Hi all, first post so be gentle....
I have a set of numbers (in a column - 5 cells) e.g. A1:A5 (may grow in size depending on answers) At the base of the column I would like to return 'Pass' if all the numbers meet the criteria, or 'Fail' if just one of the numbers are outside the criteria. I've tried various formulas such as;
IF(AND(A1:A5>=2,A1:A5<=4),"Pass","Fail")
so if any of the numbers are below 2 or above 4 then it should return 'Fail' but if all the numbers are between 2 and 4 'Pass' is returned.
Just as an extra pain in the 'A' it'd help if it didn't fire until a value was in cell A5
Thanks in advance
I have a set of numbers (in a column - 5 cells) e.g. A1:A5 (may grow in size depending on answers) At the base of the column I would like to return 'Pass' if all the numbers meet the criteria, or 'Fail' if just one of the numbers are outside the criteria. I've tried various formulas such as;
IF(AND(A1:A5>=2,A1:A5<=4),"Pass","Fail")
so if any of the numbers are below 2 or above 4 then it should return 'Fail' but if all the numbers are between 2 and 4 'Pass' is returned.
Just as an extra pain in the 'A' it'd help if it didn't fire until a value was in cell A5
Thanks in advance