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

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

In that formula you'll get a FALSE result any time Q80 doesn't equal
NOW().

You'll have to tell Excel what to display for those occasions.

If you want the cell to appear to be blank then add to the formula like
this:

=IF(Q80="closed",NOW(),"")


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401988

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

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

thanks cutter, this works also. 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