Using a range as value_if_true in IF function

  • Thread starter Thread starter Dmitry Kopnichev
  • Start date Start date
D

Dmitry Kopnichev

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?
 
Your question is not clear. And probably the formula you gave is an
arrayformula.

Mangesh
 
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?
 
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
 
Yes, infl_on=õÐÒÁ×ÌÅÎÉÅ!$D$47 is a sigle cell and it is using absolute
referencing. The formula gives E, not D 20=F56.
Why do you get D19 = E56, D20 = F56 if you use infl_on as single cell and
use absolute referencing?
 
The formula gives E19, not D20=F56.
Mangesh Yadav said:
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



IF(infl_on;Opex_inflation;1)
Click to expand...
 
The condition is single cell, and everytime you check the same conditions
for all the cells. I don't understand what you are trying to do.

Maybe if you give and example of what is your input, and what are you
expecting as output, we could give you a formula accordingly.

Mangesh
 
I'm trying to understand the logic of the calculations, which were built by
other people.
 
The formula gives write values. I just don't understand why the formula
gives the writes values from the range E56:AM56 for the write cells, why the
if function takes a cell reference from the range E56:AM56.
 
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?
 
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
 
Why is my formula not an array formula, but returns E19=F56, not E56? The
infl_on is an absolute reference.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical IF statements 3
Multiples of 4 in an IF statement 6
My Duplicate formula is not functioning as it should 3
Logical Test 5
Function for Auto Populate 3
SUMPRODUCT or SUMIF if any values in a range equal any values in another range 3
#NAME? error in nested if & VB 1
Creating popup messages for User Defines Functions 1

Back
Top