in you example is the cell you want updated "Q1"?

If so than it should read
=IF(Q80="closed",NOW())

--
Kevin


"WYN" wrote:

good day all, i am trying to get this formual ie: =if(q80="closed",q1=now())i
cant get it right. i have tried various variations of the formula.any help is
appreciated. thx wyn
--
wynb