View Single Post
  #5   Report Post  
olasa
 
Posts: n/a
Default


Sorry, I misunderstood your question.

This is one way: =IF(A1-A2<0,0,A1-A2)

Ola Sandström


Here's a short video of the IF-function:
http://www.auditexcel.co.za/docs2/IF.wmv


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390804