hi kevin, i just corrected my dislexic fingers and entered your formula
again, and it works just fine.thanks again 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