Thread: Cell display
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CrewDog130[_3_] CrewDog130[_3_] is offline
external usenet poster
 
Posts: 1
Default Cell display


I would like a to make the cell with the following formula display "N/A"
or remain blank when a date is not entered in K4. Does anyone have any
suggestions?

=((TODAY()-K4)/365)*12


--
CrewDog130
------------------------------------------------------------------------
CrewDog130's Profile: http://www.thecodecage.com/forumz/member.php?userid=612
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122178