answersLogoWhite

0

You can use the NOT function. Here are two examples, comparing values in cells A1 and A2 to see if they are equal to each other or not. The first will give either TRUE or FALSE and the second will give either Different or Same:

=NOT(A1=A2)

=IF(NOT(A1=A2),"Different","Same")

You can use the less than and greater than symbols together for not equal to. It will give either a TRUE or FALSE response.

This is False:

=6<>6

This is True:

=6<>7

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What symbol is typed first when a formula is entered in excel?

An equal sign because in order for the formula to go through correctly it has to have an (=)


What is the first thing you have to type into a cell when crating a formula?

an equal sign =


Does equal sign proceeds a formula?

If you mean in Excel, yes: you must always start a formula with an equal sign.


What alerts excel that you are entering a formula of function?

an equal sign =


What is the symbol that tells excel that you are about to begin a formula?

the asterisk is used for what function when building a formula in excel


What does equal plus mean in excel?

The combined sign has no special meaning. Any formula in Excel starts with an equal sign. To refer to a cell, you can write, for example, =A1. This can also be written as =+A1. The "+" isn't really necessary in this case. Most likely, a user started the formula with a "+" (out of old habit, since that's what people used to do in older spreadsheet programs), and Excel added the equal sign, which is required in Excel, automatically.


What does an equal sign mean in Excel?

The equal sign in Excel is used to start a formula. All formulas begin with the equals sign. It can also be used for comparing things. In the following example, the first equals sign is starting the formula and the second one is comparing cell A2 and B2: =A2=B2


How are formulas created in Excel?

Every formula, equation, or function starts with a equal sign in a given cell.


When using the Insert Function button or the AutoSum list arrow it is necessary to type the equal sign?

Not in Excel.


Does every formula in Excel start with an equal sign?

Yes, in Excel, every formula must start with an equal sign (=) to indicate to the program that it is a formula and not a regular text entry. This is a key rule in Excel syntax that helps differentiate between data and calculations. Omitting the equal sign will result in Excel treating the entry as text rather than a formula.


What is typed to represent the words Greater Than or Equal To?

Usually the symbol &ge; is used to represent the words "greater than or equal to." ____ The greater than symbol is &gt; and the equal to sign is =. The less than symbol is &lt;.


What is The preceding a formula is an important part of the formula because it alerts Excel that a formula or function is being entered and not text.?

Equal sign