What is <>

[FLKulchar]

What does <> mean?

In other words, what does A1:A10<>4 mean??

I know a true or false value is assigned, but I would
like to know more...

thanks,

Larry

 

[Tushar Mehta]

Not equal to.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Dave Peterson]

Not equal (different than).

Highlight that portion of the formula and hit F9 (calculate).

That's your array of true/falses.

(Hit ctrl-z to get that portion back or hit escape to exit the cell without
changing it.)