# 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

#1
October 10, 2014 at 20:34:46
 All Good, Sorted I think=IF(A41>=B41,IF(A41<=C41,"PASS","FAIL"),"FAIL")message edited by Smoothy84

Report •

#2
October 11, 2014 at 08:26:22
 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:=IF(AND(A41>=B41,A41<=C41),"PASS","FAIL")Which translates to if: ```2015 >= 2001 AND 2015 <= 2151 A41 >= B41 AND A41 <= C41 ```then display PASSelse FAILBoth half's of the AND() function MUST return True forit to be True, if one half is False the the AND() will returnfalse. MIKEhttp://www.skeptic.com/