If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#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? |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
clock | Wildman | Worksheet Functions | 2 | April 26th, 2005 10:31 AM |
Having trouble with multi-select list box in Access | brandelfly | New Users | 4 | February 10th, 2005 08:36 PM |
How to enter a range plus an additional cell in a function. | Lawrence M. Seldin, CMC, CPC | Worksheet Functions | 2 | May 22nd, 2004 03:30 PM |
Writing a custom function | sue | Worksheet Functions | 2 | April 5th, 2004 06:02 PM |
Worksheet function with range reference | Marie | Worksheet Functions | 3 | October 16th, 2003 11:17 PM |