if a2=a1

[Jan Kalop]

what formula would look like to perform something like that

if b1=a1 then in c1 print nothing

 

[ZAX]

what formula would look like to perform something like that

if a2=a1 then in a3 print nothing

Here,Type this in A3:
=IF(A1=A2,"")

 

[JackDanIce]

What if B1 <> A1?

 

[ZAX]

What if B1 <> A1?

I should be asking him this question?

 

[JackDanIce]

Asking the person who posted the question. Your answer will return "TRUE" if A1 <> B1

 

[Peter_SSs]

Your answer will return "TRUE" if A1 <> B1

or FALSE? (assuming all the adjustments are made to ZAX formula & its locatiomn to refer to the cells the OP mentioned )

 

[JackDanIce]

Well that too!

 

[Jan Kalop]

ohh thanks for that, but what if B1<>A1?

Didn"t think about it, but it is very important and in that case how the formula would look like ?
if b1=a1 then in c1 print nothing but if B1<>A1 then print in C1 value of B1

 

[JackDanIce]

Try in C1:

=IF(B1=A1,"",B1)

 

[Jan Kalop]

Great....thanks