A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using a range as value_if_true in IF function



 
 
Thread Tools Display Modes
  #11  
Old October 11th, 2005, 08:19 AM
Dmitry Kopnichev
external usenet poster
 
Posts: n/a
Default

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  
Old October 11th, 2005, 09:52 AM
Mangesh Yadav
external usenet poster
 
Posts: n/a
Default

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  
Old October 11th, 2005, 12:53 PM
Dmitry Kopnichev
external usenet poster
 
Posts: n/a
Default

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  
Old October 12th, 2005, 07:09 AM
Mangesh Yadav
external usenet poster
 
Posts: n/a
Default

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  
Old October 12th, 2005, 02:55 PM
Dmitry Kopnichev
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:29 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ╘2004-2024 OfficeFrustration.
The comments are property of their posters.