i also hope that we can drill in with the blank cells also.
Mine driller

"driller" wrote:

thanks for the free reply...
since there is no link, I have to do the case to case / function to function
review of a seven 7 IF's with array coercion. I need some help to find out
the numbers of logical_test criteria we can insert in the 7
ifs(and(or(and*(something like 30arrays x 7 ))))))) gosh-----If you are
interested you can see the ?post "Array Help Part 2" where we had unselfishly
succeeded on one specific formula....If we evolved further, therefore we have
a free advancement for excel users...
....I hope this is not meaningless..(as literally quoted by others)
driller for the mine...
"Allllen" wrote:

tell us what error you are seeing.
It is difficult to understand the original question.
--
Allllen


"driller" wrote:

yah
something like this
{=IF(AND(SUM(--(EXACT(name,F6))),SUM(--(EXACT(name,G6))),SUM(--(EXACT(name,H6)))),"your name","no name")}

"Bernard Liengme" wrote:

What do you mean by "log_test"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"driller" wrote in message
...
Can a formula like =if(log_test,true,false)
be possible to hit by array's basic "ctrl-shft-enter" without an error ?
Do you have any link as samples, for my advance learning?