array question

M

Mona

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
 
T

T. Valko

= {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)
 
L

Lars-Åke Aspelin

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
Click to expand...

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
 
Top