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


Hi,
Try this.
=IF(U2="","",(IF((N2<(U2-80)),U2-(N2+80),0)))
Hope I got the ()s right.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=315094