View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
GregP1962
 
Posts: n/a
Default Need excel formula for "if A1<0 adjust A2"


I think this is what you are looking for;

=if(FORMULA IN CELL<0,0,FORMULA IN CELL)


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=534943