I tried this formula in row 5: =IF(B2=1,B1,C5). It worked. Just point
the false to the next cell (result in row 5). You have not defined the
false for the last column which should fall back to all the preceding
consecutive false.
Tongjia
P. de Jong wrote:
>> Hello,
>> I have a programming problem with Excel. I have attached the file with an
> explanation of my problem.
> Who can help me with the solution?
> If something of my problem is not clear please mail me and I'll give you
> more information.
>> Thanks,
>> Bas
>> Name: Bastest.xls
> Part 1.2 Type: unspecified type (application/octet-stream)
> Encoding: x-uuencode
