*NOT* equal(!)???

T

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!
 
P

Paul Sheppard

tx12345 said:
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!
Click to expand...

Hi tx12345

<> represents not equal to

Paul
 
T

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)

:)
 
B

BenjieLop

tx12345 said:
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)

:)
Click to expand...


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

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)
 
Top