replace number if greater than

Giganews Newsgroups
Subject: replace number if greater than
Posted by:  diggs
Date: Wed, 30 Jul 2008

I have a spreadsheet that track safety data. One cell has the number of days
since an accident. It updates automatically. The other cell is the past best
number of days without an accident. I want the Past Best cell to replace its
value if the current days since accident exceeds its value. Does anyone have
any suggestions?

Replies