| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using a range as value_if_true in IF function
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? "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? |
|
#6
|
|||
|
|||
|
The formula gives E19, not D20=F56.
"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? |
|
#7
|
|||
|
|||
|
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 "Dmitry Kopnichev" wrote in message ... 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? "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? |
|
#8
|
|||
|
|||
|
Yes, sorry, that was a slip.
Mangesh "Dmitry Kopnichev" wrote in message ... The formula gives E19, not D20=F56. "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? |
|
#9
|
|||
|
|||
|
I'm trying to understand the logic of the calculations, which were built by
other people. "Mangesh Yadav" сообщил/сообщила в новостях следующее: ... 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 "Dmitry Kopnichev" wrote in message ... 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? "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? |
|
#10
|
|||
|
|||
|
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. "Mangesh Yadav" сообщил/сообщила в новостях следующее: ... 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 "Dmitry Kopnichev" wrote in message ... 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? "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? |
|
#11
|
|||
|
|||
|
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? |
|
#12
|
|||
|
|||
|
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? |
|
#13
|
|||
|
|||
|
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? |
|
#14
|
|||
|
|||
|
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? |
|
#15
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Date & Time | New Users to Excel | |||
| Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions | |||
Linear Mode
