not equal to

curator · May 14th, 2002, 06:10 PM

is that a symbol that you can place into a formula that means not equal to?

=IF(A11=0,"YEY")

so instead of this meaning if A11 is equal to 0, it means if A11 is not equal to.

Thanks

-Curator

Yogi Anand · May 14th, 2002, 06:16 PM

use <> in your IF function as appropriate.

[ This Message was edited by: Yogi Anand on 2002-05-14 17:18 ]

Mark O'Brien · May 14th, 2002, 08:12 PM

Or, would this work?

=IF(A11=0,"Nay","YEY")

Which means:

if A11 is equal to 0 then "Nay" is returned.
if A11 is not equal to 0 then "YEY" is returned. (just remove 'Nay' if you don't want anything returned when the condition is TRUE)

Yogi Anand · May 14th, 2002, 08:47 PM

Hi Mark:
My take is that Curator wanted to know if there is an operator for 'not equal to'. So my response was mainly geared for giving him '<>'

Regards!

Mark O'Brien · May 14th, 2002, 08:56 PM

I know, but variety is the spice of life.

NateO · May 14th, 2002, 08:59 PM

Quote:

Variety is the spice of life

I concur; therefore,

=IF(A11<>0,"YEY","NAY!")

NateO · May 14th, 2002, 09:00 PM

Or as Aladin A. would put it:

=IF(A11,"YEY","NAY!")

_________________
Cheers, NateO

[ This Message was edited by: nateo on 2002-05-14 20:14 ]

Jay Petrulis · May 14th, 2002, 09:12 PM

Quote:

On 2002-05-14 19:59, NateO wrote:

Quote:

Variety is the spice of life

I concur; therefore,

=IF(A11<>0,"YEY","NAY!")

I, too, concur...

=IF(NOT(A11=0),"YEY","NAY!")
or
=IF(NOT(NOT(A11<>0)),"YEY","NAY!")

OK, I'm out of this one. Curator has the goods and I don't want to distract from the relevance of the topic.

Bye,
Jay

May 14th, 2002, 08:12 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Or, would this work? =IF(A11=0,"Nay","YEY") Which means: if A11 is equal to 0 then "Nay" is returned. if A11 is not equal to 0 then "YEY" is returned. (just remove 'Nay' if you don't want anything returned when the condition is TRUE) __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 14th, 2002, 08:56 PM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I know, but variety is the spice of life. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 06:10 PM	#1
curator New Member Join Date: Mar 2002 Posts: 29	is that a symbol that you can place into a formula that means not equal to? =IF(A11=0,"YEY") so instead of this meaning if A11 is equal to 0, it means if A11 is not equal to. Thanks -Curator

May 14th, 2002, 06:16 PM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	use <> in your IF function as appropriate. [ This Message was edited by: Yogi Anand on 2002-05-14 17:18 ]

May 14th, 2002, 08:47 PM	#4
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi Mark: My take is that Curator wanted to know if there is an operator for 'not equal to'. So my response was mainly geared for giving him '<>' Regards!

May 14th, 2002, 09:00 PM	#7
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Or as Aladin A. would put it: =IF(A11,"YEY","NAY!") _________________ Cheers, NateO [ This Message was edited by: nateo on 2002-05-14 20:14 ]