*Any* error message will produce #####, when the cell is too narrow to
display it (error msg)!

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sloth" wrote in message
...
=IF((J29="")*(K29=""),"",N28+K29)

I was trying to figure out why you are getting the ###### error. If K29
contained "" you would get a #VALUE! error instead of a ######. I thought
maybe N29 was formatted as a date and N28 was a negative number. That
would
give you a ###### error. Or having the cell to thin would also give you
the
###### error. Just because a referenece cell is blank won't give you that
error.

"Ningster" wrote:


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