IF(AND(CountIf(...<> problem

....but in ROW 2 neither B2 nor C2 are < A2 so the COUNTIF returns 0, hence the formula returns A2 rather than a blank.

I don't really understand what you are trying to do, can you clarify?

The column Letters are not good. Let me fix it.

.........A........B.........C........D..
1......1,57....4,42....7,08....1,57
2......1,65....4,50....1,65....1,65
3......2,20....3,86....3,53....2,2
4......9,61....4,00....7,25....""

So, i want in Column D the value of Column A if only the value of Column A is less than the value of Column B, less than the value of Column C and not equal with the Value in Column B and not equal with the value in Column C.

So if value in A column is < than B and C and <> with B and C -----> = value of Column A. IF not then ""

The D column is working the function.

Try this version

=IF(COUNTIF(B1:C1;">"&A1)=2;A1;"")

Originally Posted by daddylonglegs

=IF(COUNTIF(B1:C1;">"&A1)=2;A1;"")

COUNTIF is counting how many of B1 and C1 are > A1 - if that's 2 then they both must be larger (not equal)

If you want to do the same comparison but on non-adjacent cells like comparing A1 and C1 to B1 then try like this

=IF(AND(A1>B1;C1>B1);B1;"")