Thread: ###### Wrong Formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ningster Ningster is offline
external usenet poster
  
Posts: 1
Default ###### Wrong Formula

I use this formula for Cell N29:
=IF(J29="","",N28+K29)

I think what I want is if both cell nos. J29 and K29 have no value, the
formula for N29 to be blank instead of showing ######

I don't know how to do it
IF(J29 and K29="","",N28+K29)

Or do I need to use the AND( formula if both J29 and K29 are blank?


--
Ningster
------------------------------------------------------------------------
Ningster's Profile: http://www.excelforum.com/member.php...o&userid=36052
View this thread: http://www.excelforum.com/showthread...hreadid=559290

Reply With QuoteReply With Quote