| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is this possible ?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
Check he
http://www.cpearson.com/excel/array.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
thanks, i got it,
=sum(if...... how about {=if(sum........} "Niek Otten" wrote: Check he http://www.cpearson.com/excel/array.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
OK, for you "log" = logic
I do math so for me "log" = logarithm hence my confusion best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "driller" wrote in message ... 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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
is there any link for my question?
thanks for reading. "Bernard Liengme" wrote: OK, for you "log" = logic I do math so for me "log" = logarithm hence my confusion best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "driller" wrote in message ... 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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
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? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is this possible ?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
