Hi,

I think what you are trying to do is logical floored. see:

Example:If cell A1 is greater than or equal to B1, I
would like to print "1" in cell A3 otherwise blank cell,

cool (=if(a1=b1,1,"")

and if A1=B1andB1=C1 print "2" in cell A3 otherwise
blank,

what do i print if a1b1, but b1<c1, blank or 1?

and if A1=B1 and B1=C1 and C1=D1 print "3" in
cell A3.

same agian.

I think i see what your trying to do, might this work


=IF(AND(A1=B1,B1=C1,C1=D1),3,IF(AND(A1=B1,B1= C1),2,IF(AND(A1=B1),1,"")))

good luck
Ross