How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

Use the not equal operator, <. IF(A1<"Yes",True,False)

Tyro

"Neon520" wrote in message
...
How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

=IF(A1<"YES","A1 is not Yes","A1 equals Yes")

Rick


"Neon520" wrote in message
...
How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

Hi Neon,

< is the symbol for not equal to

HTH
Martin


"Neon520" wrote in message
...
How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

Like this:

=IF(A1<"Yes",do_something,do_someting_else)

--
Biff
Microsoft Excel MVP


"Neon520" wrote in message
...
How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

THANKS FOR THE RAPID REPLY, EVERYONE!!!
YOU GUYS HAVE BEEN REALLY HELPFUL!!!


"T. Valko" wrote:

Like this:

=IF(A1<"Yes",do_something,do_someting_else)

--
Biff
Microsoft Excel MVP


"Neon520" wrote in message
...
How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

On Monday, January 14, 2008 at 4:43:03 PM UTC-5, Neon520 wrote:
How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

I am trying to use the SUMIF function. And it is not accepting the < as not equal function. Here is the formula that is giving the error:

=SumIF(D3:D49,<"*Project Management",(C3:C49))

I am basically trying to sum up the rows for all entries that are not Project Management.

--

STATEMENT OF CONFIDENTIALITY:

This email may be confidential and/or protected by privilege. If you are
not the intended recipient, disclosure, copying, distribution and/or use
are prohibited; please notify us immediately at and
delete this copy from your system.

Hi,

Am Fri, 15 Dec 2017 07:22:31 -0800 (PST) schrieb
:

I am trying to use the SUMIF function. And it is not accepting the < as not equal function. Here is the formula that is giving the error:

=SumIF(D3:D49,<"*Project Management",(C3:C49))

I am basically trying to sum up the rows for all entries that are not Project Management.

the operator must be in quotes.
Try:
=SUMIF(D3:D49,"<*Project Management",C3:C49)
or
=SUMIF(D3:D49,"<" &"*Project Management",C3:C49)


Regards
Claus B.
--
Windows10
Office 2016

On 12/15/2017 at 11:34:42 AM Claus Busch wrote:

Hi,

Am Fri, 15 Dec 2017 07:22:31 -0800 (PST) schrieb
:

I am trying to use the SUMIF function. And it is not accepting the
< as not equal function. Here is the formula that is giving the
error:

=SumIF(D3:D49,<"*Project Management",(C3:C49))

I am basically trying to sum up the rows for all entries that are
not Project Management.

the operator must be in quotes.
Try:
=SUMIF(D3:D49,"<*Project Management",C3:C49)
or
=SUMIF(D3:D49,"<" &"*Project Management",C3:C49)


Regards
Claus B.

Inexperienced Excel user here! :-)

What does the asterisk do in this part of the formula?

"<" &"*Project Management"

I don't think that it multiplies anything, right?

--
tb

Hi,

Am Fri, 15 Dec 2017 19:07:01 +0000 (UTC) schrieb tb:

What does the asterisk do in this part of the formula?

"<" &"*Project Management"

I don't think that it multiplies anything, right?

that is a placeholder for other text. The OP looks for cells with
"Project Management" at the end of the text.


Regards
Claus B.
--
Windows10
Office 2016