hi there,
Is there an argument like F5=39 where I could say F5 "DOES NOT EQUAL" 39? Is there some operator that can do that? How would I accomplish that without creating an AND() argument?
Thanks!
Mike
2007-11-27 15:49:36 · 8 answers · asked by John Relling 1 in Computers & Internet ➔ Software
example:
If F5 is not equal to 35, it should say "failed" otherwise "pass":
=if( F5<>35,"Failed","Passed")
try it.
2007-11-27 16:13:01 · answer #1 · answered by ♠ jhun ♠ 6 · 6⤊ 0⤋
Not Equal In Excel
2016-12-16 14:45:05 · answer #2 · answered by holness 4 · 0⤊ 0⤋
Excel Not Equal
2016-09-28 03:54:54 · answer #3 · answered by arieux 4 · 0⤊ 0⤋
Excel includes a NOT function, so you could say
=IF(NOT(F5=39),"yes","no")
2014-12-23 04:11:27 · answer #4 · answered by Neil 7 · 1⤊ 0⤋
Just make a formula =f5<>39 and push enter and it will Show the True value if f5 is not equal to 39.........Hope this helps
2007-11-27 16:07:41 · answer #5 · answered by erika g 2 · 2⤊ 2⤋
F5<>39 (that is not one symbol, it is less than sign and greater than sign right beside each other)
2007-11-27 15:52:10 · answer #6 · answered by CB 7 · 4⤊ 0⤋
Format => conditional formatting =>"is not equal to"
is one of the choices in the drop-down box
2007-11-27 15:54:04 · answer #7 · answered by atheistforthebirthofjesus 6 · 1⤊ 3⤋
.=
2016-10-04 03:33:00 · answer #8 · answered by gabanielz 1 · 0⤊ 0⤋
check the database
2007-11-27 15:51:37 · answer #9 · answered by sburnett06 2 · 0⤊ 7⤋