Thread: Search for 2 true arguments and return true or false
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
davesexcel davesexcel is offline
external usenet poster
  
Posts: 1
Default Search for 2 true arguments and return true or false

try this adjust to your needs

=IF(COUNTBLANK(A1:E1),"Error",NOW())

now() shows todays date, you can change it to what ever you require


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=561699

Reply With QuoteReply With Quote