Thread: Array function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Array function

Depends what you want to do, but here's one approach:

=IF(X1="",0,array_formula)

commit with CTRL-SHIFT-ENTER.

However, if you want an alternative non-array solution to your earlier
post, check out my answer.

Hope this helps.

Pete

On Apr 23, 2:14*pm, nc wrote:
How can I include an array function within an IF function?

Thanks.