G

#### Guest

number based on the results of the comparison.

Example:

Sum cells A1:A4

Compare to Sum of cells B1:B4 and Sum of cells C1:C4.

If A1:A4>B1:B4 & C1:C4 then return value of 4

If A1:A4<B1:B4 & C1:C4 then return value of 0

If A1:A4>B1:B4 & A1:A4<C1:C4 then return value of 2

If A1:A4=B1:B4 & A1:A4=C1:C4 then return value of 3

I have 12 different combinations to compare and a different value for each

result. I have tried the IF(AND function but this limits me to 7 nested IF

statements.

This is driving me nuts, Please help me find another way!

Thanks