simple formula to count cells

N

newbie

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.
 
C

Cecilkumara Fernando

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
 
R

ross

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,
Click to expand...

cool (=if(a1>=b1,1,"")
and if A1=>B1andB1=>C1 print "2" in cell A3 otherwise
blank,
Click to expand...

what do i print if a1>b1, but b1<c1, blank or 1?
and if A1=>B1 and B1=>C1 and C1=>D1 print "3" in
cell A3.
Click to expand...

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
 
Top