Thread: check to see if a cell is blank if not populate adjacent cell wit.
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
  
Posts: 281
Default check to see if a cell is blank if not populate adjacent cell wit.
Hi,

May be this works for you:

=IF(ISBLANK(A1),"",TODAY())

Thanks,
--
Farhad Hodjat


"Frusterated" wrote:

Hello need help with a formuala. In a spreadsheet I want to check and see
iif a cell contains text, if so, I want to populate an adjacent cell with the
current date. If the cell is blank I dont want to do anything... Thanks.
Reply With QuoteReply With Quote