= if formula needed

W

WYN

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
 
K

Kevin

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

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

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

WYN

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
 
W

WYN

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