simple formula to count cells
 

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.

simple formula to count cells
 

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.

simple formula to count cells
 

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