On 23 Sep 2006 23:45:45 -0700, "roohbir" wrote:

Well, that is because my data starts from A1 and ends at A13. So, I
changed the values accordingly, although the logic is the same.
Roohbir

Please reread what I wrote.

Your formula is WRONG

The logic is NOT the same. The cell references are irrelevant.

"" is NOT THE SAME AS "<="

Can you not see that

"GREATER THAN"

is different than

"LESS THAN OR EQUAL TO"

??


--ron