LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 12
Default Logical functions AND,OR in array formulas work ?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formulas for logical functions Judi Excel Discussion (Misc queries) 1 May 19th 09 01:49 AM
Formulas assignment from array to range in VSTO Excel doesn't work vsto excel array to range Excel Worksheet Functions 0 December 11th 07 04:48 PM
Can array formulas work if rows are inserted? Chris Excel Worksheet Functions 1 March 16th 06 03:30 PM
how array functions work mmult,minverse etc ramki Excel Worksheet Functions 4 March 2nd 06 02:36 PM
Work around for limit on entering array formulas? quartz[_2_] Excel Programming 2 December 1st 04 11:21 PM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"