equation symbols

[AndrewRossington]

Does anyone know what to type into the criteria of an IF formula when you want to say if a cell isn't equal to another? Which symbols do I use? Is it a combintion of = (equals) and something else?

Thanks

 

[MarkAndrews]

Just change the statement round

EG -

=IF(A1=B1,"",32323)

 

[jindon]

Does anyone know what to type into the criteria of an IF formula when you want to say if a cell isn't equal to another? Which symbols do I use? Is it a combintion of = (equals) and something else?

Thanks

<> should do..

 

[AndrewRossington]

Ha ha, but of course!

Thanks buddy, I appreciate that.