Thread: Auto Date in a cell if other cell is greater than 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shaggy Shaggy is offline
external usenet poster
  
Posts: 7
Default Auto Date in a cell if other cell is greater than 1
Can anyone help,
I need a formula to automatically put the current date into a cell if the
cell next to it is greater than 1
EG. If 'A5' = 1000 then 'B5' = Todays Date
Reply With QuoteReply With Quote