Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Following Carim's suggestion I rewrote my array formulas to include */
+ in place of and/or and now they are working fine. Thanks too for that sumproduct function and that trick of highlighting part of your formula and evaluating it with F9 - it's very useful. It seems that the mistake I made was about thinking that {OR{t,f,t,f}, {t,t,f,f}} evaluates to an array of {t,t,t,f} and not to the simple {t} Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Formulas for logical functions | Excel Discussion (Misc queries) | |||
Formulas assignment from array to range in VSTO Excel doesn't work | Excel Worksheet Functions | |||
Can array formulas work if rows are inserted? | Excel Worksheet Functions | |||
how array functions work mmult,minverse etc | Excel Worksheet Functions | |||
Work around for limit on entering array formulas? | Excel Programming |