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.
|