*NOT* equal(!)???

[tx12345]

Hi,

What I am trying to figure out to do is so simple it truly boggles my mind that I have not yet figured this out.

How the heck can you simply say NOT EQUAL!???

Example,

=and(a2=a3,a3=a4,a4 DOES NOT EQUAL a5)

Is there any way one can simply put a does not equal sign in the formula? Otherwise you have to get into all htis convolucded stuff with the NOT function, or > or < than, and on an on.

TIA!

[Paul Sheppard]

Hi,

What I am trying to figure out to do is so simple it truly boggles my mind that I have not yet figured this out.

How the heck can you simply say NOT EQUAL!???

Example,

=and(a2=a3,a3=a4,a4 DOES NOT EQUAL a5)

Is there any way one can simply put a does not equal sign in the formula? Otherwise you have to get into all htis convolucded stuff with the NOT function, or > or < than, and on an on.

TIA!

Hi tx12345

<> represents not equal to

Paul

[tx12345]

Thanks! Sorry it took so long to reply. Been a busy time.

So, that is all it was? <>? Geez, *now* I really feel dumb! This is an example of how I was treating does not equal:

=IF(AND(NOT(Y122="")),Y122,#N/A)

next time it's: =IF(AND(Y122<>""),Y122,#N/A)

[BenjieLop]

Thanks! Sorry it took so long to reply. Been a busy time.

So, that is all it was? <>? Geez, *now* I really feel dumb! This is an example of how I was treating does not equal:

=IF(AND(NOT(Y122="")),Y122,#N/A)

next time it's: =IF(AND(Y122<>""),Y122,#N/A)

You do not need "AND" in your formula. Instead of

=IF(AND(Y122<>""),Y122,#N/A)

it should simply be

=IF(Y122<>"",Y122,#N/A)

Regards.

[Cutter]

Except you don't need the AND() function in the formula you're using. You only have one condition to check for so there's no "and" involved.

Your formula is simply =IF(Y122<>"",Y122,#N/A)