| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Question | Excel Discussion (Misc queries) | |||
| array question | Excel Worksheet Functions | |||
| another array question | Excel Worksheet Functions | |||
| Array Question | Excel Discussion (Misc queries) | |||
| Array Question | Excel Worksheet Functions | |||
Threaded Mode
