Return the conditions from Nos.

[thilag]

Dear Friends

I want to add the Numbers inside the boxes in C Column according to
the position from A or B. I want to add the Nos. from A to B or B to A
then if it is 0 or 9, the formula should print the value `TRUE'
if it is not 0 or 9, then the formula should print the value `FALSE'

thanks in advance


thilagIF.xls

[FDibbins]

I looked at your data, and none of the amounts total more than 9 or 0, please check your calcs again.

I used this formula to calc the amounts...
=SUM(INDIRECT("C"&IF(MATCH("A",D1:D12,0)<MATCH("B",D1:D12,0),MATCH("A",D1:D12,0),MATCH("B",D1:D12,0))&":C"&IF(MATCH("A",D1:D12,0)<MATCH("B",D1:D12,0),MATCH("A",D1:D12,0),MATCH("B",D1:D12,0))+5)).

wrapping it in or() and repeating it for = 9 or = 0 will give you TRUE or FALSE

[thilag]

IF2.xls

Dear Mr. FDibbins

Thanks for your immediate reply

Refer the new file, Green = Result by formula Yellow = varying inputs

Actually it is simple misunderstanding.And Sorry Iam not explaind properly
A and B will not repeat more than 1 time.

Sum of C3:C9 = 9 and the formula should work for the
letters in Coloumn D to O and the values in Column C.

In elloborate words in D3, E13, G13, H13, I13, J13, K13, M13, N13 and O13
the formula result should be FALSE, since the condition is not macthing
and the F13 and L13 it should be TRUE since Sum of C3:C9 = 9

Also If Sum of C3:C9 = 0 then also it should return TRUE.


thanks in advance

thilag