Tag: Array Constants

I have been recently blogging on Array Constants (see below links) and how useful they are for simpler, more maintainable and readable formulas.  ttps://www.theexcelfactor.com/using-array-constants-formulas-logic/ https://www.theexcelfactor.com/using-array-constant-list-formulas/ Also I often use SUMIFS which from the top of my head came with Excel …

More Useful Array Constant Formulas Read More »

Tagged with: , , ,

This is a short PS post to my earlier post on using Array Constants in Formulas basically to simplify them.   The focus of the earlier post was avoiding Nested IFs but what about simplifying OR logic situations. Try… =OR(B5={“A”,”B”,”D”}) will …

Using Array Constants in Formulas again – OR logic Read More »

Tagged with: , , ,

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 …

Using Array Constants in your formulas Read More »

Tagged with: , ,