Solved How do i create a formula to give a yes or no answer

October 10, 2014 at 19:17:13
Specs: Windows 7
I have created a sheet for our daily count's, it gives me an upper and lower limit for the next days counts, but what i need to to create a coloum at the end to say whether it pass's or not, if this makes sence eg. Daily count is 2015 the lower is 2001 and the upper is 2151 i need get this to work. im a newbi at this to, so thanks for the help in advance :)

See More: How do i create a formula to give a yes or no answer

Report •

October 10, 2014 at 20:34:46
All Good, Sorted I think


message edited by Smoothy84

Report •

October 11, 2014 at 08:26:22
✔ Best Answer
If the formula works for you, then use it.

But without knowing what numbers, go in what cells,
it is difficult to know if we can help,
but I get the feeling that there may be another solution.

Guessing at what number go where, then something like:


Which translates to if:

2015 >= 2001 AND  2015 <= 2151 
 A41 >= B41  AND  A41  <= C41

then display PASS
else FAIL

Both half's of the AND() function MUST return True for
it to be True, if one half is False the the AND() will return


Report •

October 11, 2014 at 17:27:00
Nail on the head Mike.

Cheers mate :)

Report •

Related Solutions

Ask Question