View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
orquidea orquidea is offline
external usenet poster
 
Posts: 132
Default If formula - URGENT

Hi

I want a formula which automaticaly types the current date and time when
data have been entered in the cell beside. ie.

A B
DOG =if(A1="",(=NOW()) dd/mm/yy hh:mm

But this one doesn't work.

Could anyone help me please.

Thanks
Orquidea