what is format are you using? What is the value of N28?

*Pasted from help*
A ##### error value occurs when the cell contains a number, date, or time
that is wider than the cell or when the cell contains a date and/or time
formula that produces a negative result.

"Ningster" wrote:


Can someone tell me what I'm doing wrong? I used this formula for Cell
N29:
=IF(J29="","",N28+K29)

The problem is if no value is yet entered into K29, I get ######

What formula can I use to resolve this problem?


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