Excel Programming Problem

Tongjia Yin tjyin at bio.indiana.edu
Thu Oct 31 12:19:55 EST 1996


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




More information about the Bio-soft mailing list