hi kevin,thanks for replying.i changed the formula to the one you suggested
nad in q1 i get #name? not sure how to stop this. thx wyn
--
wynb


"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