array question
 

I have a simple formula = {if(dummy=False,0,dummy_range)}. This formula is
copied in cell A2:C4. Dummy_range = f2:H4. F2:H4 has numeric data from
external workbook. I can't get the formula to work. When I copy the formula
in Cells A2:c4 all I get is "1". ??

Example data
F G H
1 3 5
3 2 2
4 1 1

array question
 

= {if(dummy=False,0,dummy_range)}

Is there a difference between "dummy" and "dummy_range"?

This (array) formula works just fine:

=IF(dummy_range=FALSE,0,dummy_range)

--
Biff
Microsoft Excel MVP


"Mona" wrote in message
...
I have a simple formula = {if(dummy=False,0,dummy_range)}. This formula is
copied in cell A2:C4. Dummy_range = f2:H4. F2:H4 has numeric data from
external workbook. I can't get the formula to work. When I copy the
formula
in Cells A2:c4 all I get is "1". ??

Example data
F G H
1 3 5
3 2 2
4 1 1

array question
 

On Tue, 23 Mar 2010 13:03:01 -0700, Mona
wrote:

I have a simple formula = {if(dummy=False,0,dummy_range)}. This formula is
copied in cell A2:C4. Dummy_range = f2:H4. F2:H4 has numeric data from
external workbook. I can't get the formula to work. When I copy the formula
in Cells A2:c4 all I get is "1". ??

Example data
F G H
1 3 5
3 2 2
4 1 1

You have to select the entire range A2:C4, type the formula
=IF(dummy=False,0,dummy_range) in the formula field and
then "array enter" it.

That means that you have to hold down CTRL and SHIFT while you push
ENTER.
You should not type the curly brackets, Excel will insert them for you
as an acknowledgement that you have made an "array enter".

Hope this helps / Lars-Åke