Try,
=IF(AND(D1=C1,C1=B1,B1=A1),3,IF(AND(C1=B1,B1= A1),2,IF(B1=A1,1,0)))
watch for the line warp in mail above formula should be in one line
Cecil

"newbie" wrote in message
...
I would appreciate your help with this formula.
Cells A1,B1,C1and D1 have number values. Cell A3 counts
the number of consecutive increasing numbers from D1 to
A1.Example:If cell A1 is greater than or equal to B1, I
would like to print "1" in cell A3 otherwise blank cell,
and if A1=B1andB1=C1 print "2" in cell A3 otherwise
blank, and if A1=B1 and B1=C1 and C1=D1 print "3" in
cell A3.

Thanks for your assistance.