is this possible ?

[Guest]

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?

 

[Niek Otten]

Check here:

http://www.cpearson.com/excel/array.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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?

 

[Bernard Liengme]

What do you mean by "log_test"
best wishes

 

[Guest]

thanks, i got it,

=sum(if......

how about {=if(sum........}

 

[Guest]

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

 

[Bernard Liengme]

OK, for you "log" = logic
I do math so for me "log" = logarithm
hence my confusion
best wishes

 

[Guest]

is there any link for my question?
thanks for reading.

 

[Guest]

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

 

[Guest]

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...

 

[Guest]

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