small with condition

[Guest]

You have to put this in a new column i.e W, otherwise you
get circular references
=IF(V99="",MIN(T99,M99),V99)

-----Original Message-----
Column M Column T Column V
revision date orig realistic completion date
Row 99 05/17/04 05/17/04
Row 100 3/1/05 05/24/04 05/24/04
Row 101 07/09/04 07/30/04
Row 102 07/12/04 07/12/04
Row 103 8/3/04 07/22/04
Row 104 8/3/04 07/28/04
Row 105 8/16/04 08/02/04
Row 106 08/03/04 08/12/04
Row 107 8/3/04 08/20/04
Row 108 TBD 09/10/04
Row 109 09/24/04
Row 110 12/16/04 10/11/04