I have created this formula but it is giving the result "0", when if fact what should showing is "2", even in the formula checker I gone through it systematically and it only results in "0", this is based on the $c87 cell content being a No.4 and the AV80 cell content being a No.1. I know it is to do with a true/false statement but because of the nesting the formula reading right but results wrong and I can't seem to correct it - can anyone see what I done wrong and point out the error I have made! to me thank-you