###### Wrong Formula

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?

What do you want to get if K29 has no value? this will give you N28

=IF(J29="","",SUM(N28,K29))

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

If no value is yet entered into K29, I want N29 to be blank instead of showing ######

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
>
>

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?

hi Ningster,

The below shows two approaches using the AND function:

=if(and(isblank(j29),isblank(k29)),"",N28+K29)
or
=if(and(j29="",k29=""),"",N28+K29)

As Sloth mentioned the ##### effect could be caused by the values contained within the cells, what type of data is in them?

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

data consist of a 1-decimal number no greater than 100

=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
>
>

*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" <[email protected]> wrote in message
news:[email protected]...
> =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
>>
>>