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

Thank you! This is exactly what I was trying to get.

"Casey" wrote:


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