View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Can anyone answer this question?

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