The formula is not an array formula.
The IF(logical_test,a1:z1,value_if_false) is IF(infl_on;Opex_inflation;1) in
cells D19:AK19. The Opex_inflation is E56:AM56. Why does the
IF(infl_on;Opex_inflation;1) use values from E5 in D19 to AM56 in AK19, not
the same value?
"Mangesh Yadav" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: ...
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?