Tag: LOOKUP

Using Array Constants in your formulas

I find I use this kind of formula a lot… =IF(AND(B5<>{“A”,”B”,”C”,”D”}),”Yes”,”No”) Instead of =IF(AND(B5<>”A”,B5<>”B”,B5<>”C”,B5<>”D”),”Yes”,”No”) And imagine if you want to test for 20 items B5 is not equal to?  It’s shorter and easier to read and edit.  I discovered this

Tagged with: , ,
Top