Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




not equal to symbol in excel
What is the symbol for not equal to in excel

#2




Answer: not equal to symbol in excel
The symbol for not equal to in Excel is <. It is used to compare two values and returns a TRUE or FALSE result. For example, if you want to check if the value in cell A1 is not equal to the value in cell B1, you can use the formula "=A1<B1". This will return TRUE if the values are not equal and FALSE if they are equal. You can also use this symbol in combination with other operators, such as greater than or less than, to create more complex comparisons. For example,
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.misc




not equal to symbol in excel
Hi
< Arvi Laanemets "amit" wrote in message ... What is the symbol for not equal to in excel 
#4
Posted to microsoft.public.excel.misc




not equal to symbol in excel
I disagree. Those symbols mean less than and greater than.
Go to your Insert dropdown menuSymbol ‰*...this is the equal sign with a slash through it. When you click on it, the "Code" or "definition" will show up on the left side of the box. "Arvi Laanemets" wrote: Hi < Arvi Laanemets "amit" wrote in message ... What is the symbol for not equal to in excel 
#5
Posted to microsoft.public.excel.misc




not equal to symbol in excel
Interpretation is the problem here, as I see it.
For purposes of calculation operations the comparison operator < means not equal. For purposes of "Symbol" the slashed = sign is correct. All depends upon what OP was referring to. Gord Dibben Excel MVP On Sun, 4 Dec 2005 11:22:02 0800, "Armadillow" wrote: I disagree. Those symbols mean less than and greater than. Go to your Insert dropdown menuSymbol ?...this is the equal sign with a slash through it. When you click on it, the "Code" or "definition" will show up on the left side of the box. "Arvi Laanemets" wrote: Hi < Arvi Laanemets "amit" wrote in message ... What is the symbol for not equal to in excel 
#6
Posted to microsoft.public.excel.misc




not equal to symbol in excel
Ive always used the NOT(A1=B1) function, as the < does not work for me
either. "Armadillow" wrote in message ... I disagree. Those symbols mean less than and greater than. Go to your Insert dropdown menuSymbol ?...this is the equal sign with a slash through it. When you click on it, the "Code" or "definition" will show up on the left side of the box. "Arvi Laanemets" wrote: Hi < Arvi Laanemets "amit" wrote in message ... What is the symbol for not equal to in excel 
#7
Posted to microsoft.public.excel.misc




not equal to symbol in excel
Gotta. I mispoke. All depends upon what OP was referring to. Thanks for
the addittional information. "Gord Dibben" wrote: Interpretation is the problem here, as I see it. For purposes of calculation operations the comparison operator < means not equal. For purposes of "Symbol" the slashed = sign is correct. All depends upon what OP was referring to. Gord Dibben Excel MVP On Sun, 4 Dec 2005 11:22:02 0800, "Armadillow" wrote: I disagree. Those symbols mean less than and greater than. Go to your Insert dropdown menuSymbol ?...this is the equal sign with a slash through it. When you click on it, the "Code" or "definition" will show up on the left side of the box. "Arvi Laanemets" wrote: Hi < Arvi Laanemets "amit" wrote in message ... What is the symbol for not equal to in excel 
#8
Posted to microsoft.public.excel.misc




not equal to symbol in excel
I don't know which version of Excel you have, but < has always worked for me.
 Regards, Fred "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message ... Ive always used the NOT(A1=B1) function, as the < does not work for me either. "Armadillow" wrote in message ... I disagree. Those symbols mean less than and greater than. Go to your Insert dropdown menuSymbol ?...this is the equal sign with a slash through it. When you click on it, the "Code" or "definition" will show up on the left side of the box. "Arvi Laanemets" wrote: Hi < Arvi Laanemets "amit" wrote in message ... What is the symbol for not equal to in excel 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???  Excel Discussion (Misc queries)  
label caption equal excel value  Excel Worksheet Functions  
How do I insert a symbol BEFORE text for multiple cells in Excel?  Excel Worksheet Functions  
Not printing symbol in excel  Excel Discussion (Misc queries)  
Difference in number of Excel NewsGroups  Excel Discussion (Misc queries) 