View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Can anyone answer this question?

Yes,

LOL, but as you say 'what practical value'

Next test, can you make it display false and this doesn't count.

=IF(1=1,{FALSE,TRUE})

Mike

"Ron Rosenfeld" wrote:

On Tue, 22 Dec 2009 12:01:01 -0800, Mike H
wrote:

It would be an interesting IF statement that returned both TRUE and FALSE :)


Well, you could due that with an array formula:

=IF(1=1,{TRUE,FALSE})

What practical use this might have is beyond me, however. :-)

--ron
.