Your question is not clear. And probably the formula you gave is an
arrayformula.

Mangesh


"Dmitry Kopnichev" wrote in message
...
Hello
Why does IF(logical_test,a1:z1,value_if_false) in one cell use a value in
sell z1 and in another cell use a value in cell a1?