I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECF

You might want to take a look at the OR/AND functions (XL help file). For
what you have so far:
=IF(OR(A1=A2,A2<A3),1,0)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ecf123" wrote:

I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECF

Hi,

I am trying to count the cells in a column ending with a particular letter.
Cells contain alphanumeric values. For ex: =COUNTIF(W5:W7,"*P") This is
giving zero as the answer instead of 2. Please help..


"Luke M" wrote:

You might want to take a look at the OR/AND functions (XL help file). For
what you have so far:
=IF(OR(A1=A2,A2<A3),1,0)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ecf123" wrote:

I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECF

You probably have invisible characters *after* the final "P".

Maybe <Space or the non-breaking, often used web space, Char(160).

Do a character count of one of the cells in question,
=Len(a1)
and compare the number to what you can see.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"David" wrote in message
...
Hi,

I am trying to count the cells in a column ending with a particular letter.
Cells contain alphanumeric values. For ex: =COUNTIF(W5:W7,"*P") This is
giving zero as the answer instead of 2. Please help..


"Luke M" wrote:

You might want to take a look at the OR/AND functions (XL help file). For
what you have so far:
=IF(OR(A1=A2,A2<A3),1,0)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ecf123" wrote:

I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECF

ecf123;423499 Wrote:
I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECFyou want to count entries where? in what range? where would you like the
formula to go?

2 ways of doing it in B1 (or wherever)
=IF(A1=A2,1,IF(A1<A2,0,IF(A2<A3,1,0))) or =IF(OR(A1=A2,A2<A3),1,0)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117750

Hi,
if(OR(a1=a2,a2<a3),1,0)

"ecf123" wrote:

I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECF

=--OR(A1=A2,A2<A3)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"ecf123" wrote in message
...
I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECF

Hi,

Let me be a stickler - if A2=A3 what happens?

As asked you might write

=--AND(A1=A2,A2<A3)

or


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"ecf123" wrote:

I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECF