I see =IF(infl_on;Opex_inflation;1), not {=IF(infl_on,Opex_inflation,1)}.
"Mangesh Yadav" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: ...
just to be clear, when you select the cell E19, what do you see in the
formula bar

do you see
=IF(infl_on;Opex_inflation;1)

or do you see
{=IF(infl_on,Opex_inflation,1)}


Mangesh



"Dmitry Kopnichev" wrote in message
...
Why is my formula not an array formula, but returns E19=F56, not E56?
The
infl_on is an absolute reference.
"Mangesh Yadav" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: ...
Hi Dmitry,

Lets start from the beginning again.

Opex_inflation is E56:AM56
and the formula you use is IF(infl_on;Opex_inflation;1) in cells
D19:AK19

Now,

Case1: if you enter the above formula as an simple formula, then you
would
get E19=E56

Case2: if you enter the above formula as an arrayformula, then you
would
get
E19=F56


Mangesh




"Dmitry Kopnichev" wrote in message
...
Dear Mangesh,
Why do you get E19 = F56, not E19 = E56 or any other call in
E56:AM56,
if
you use infl_on as single cell and use absolute referencing?
"Mangesh Yadav" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: ...
What is infl_on. Is it a range, or a single cell. If it is sigle
cell
then
are you using absolute referencing. You are expecting that D19 =
E56,
D20
=
F56, and so on right. which is what I get if I use infl_on as
single
cell
and use absolute referencing.



Mangesh



"Dmitry Kopnichev" wrote in message
...
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?