View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Newbie Newbie is offline
external usenet poster
 
Posts: 7
Default 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.