View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES


=IF(A1<=0,A1,"")
see if this works


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