= if formula needed

[Guest]

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

 

[Guest]

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

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

 

[Cutter]

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(),"")

 

[Guest]

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

 

[Guest]

hi kevin, i just corrected my dislexic fingers and entered your formula
again, and it works just fine.thanks again wyn.

 

[Guest]

thanks cutter, this works also. wyn