IF Statements

Oct 29, 2010
Reaction score
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;


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question