View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tcgaines
 
Posts: n/a
Default If Cell Value < 0, Change Value to 0


The subject says it all. I want to search a range for cell values that
are < 0 and if they are, change the value to 0. how do i do that?

thx


--
tcgaines
------------------------------------------------------------------------
tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608
View this thread: http://www.excelforum.com/showthread...hreadid=496840