requirement ... test each cell for negative value. if true, b1=value of
previous cell
sample:
A B
1 10 5
2 5
3 -1
thank you.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.534 / Virus Database: 329 - Release Date: 10/31/2003