Thread: If formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Casey Casey is offline
external usenet poster
 
Posts: 1
Default If formula


Try:

IF(AND(L34=0,F34=0),F35-L35, IF(F34=0,L34+F35,L35-F35)).

HTH


--
Casey


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