is this possible ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
yah
something like this
{=IF(AND(SUM(--(EXACT(name,F6))),SUM(--(EXACT(name,G6))),SUM(--(EXACT(name,H6)))),"your name","no name")}
 
OK, for you "log" = logic
I do math so for me "log" = logarithm
hence my confusion
best wishes
 
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...
 
Back
Top