View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WYN
 
Posts: n/a
Default excel formual needed

good day all,i need a formula to do the following.=if(q80=closed,q1=now())
i want q1 to show the date by entering the word closed in cell q80? any help
is appreciated.
--
wynb