Formula Error
 

xl2000
My formula works fine but it has the #value! error. what do I add to my
formula to rid myself of this?

=IF(C37+D37,C37+D37,"")+D36*D35

Thanks

It's not clear to me what you're checking for in the IF formula. You
should be able to change this to:

=C37+D37+D36*D35



Mike R wrote:
xl2000
My formula works fine but it has the #value! error. what do I add to my
formula to rid myself of this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi!

Replace the "" with a zero.

BTW, if your formula returns a #VALUE! error, it's not
working fine. <g

Biff

-----Original Message-----
xl2000
My formula works fine but it has the #value! error. what
do I add to my
formula to rid myself of this?

=IF(C37+D37,C37+D37,"")+D36*D35

Thanks
.

Thanks for the return here "Biff"
Sorry I was short on good info there. the only time it return the error is
before any data is entered. once that happens it does work fine. thanks
again

"Biff" wrote:

Hi!

Replace the "" with a zero.

BTW, if your formula returns a #VALUE! error, it's not
working fine. <g

Biff

-----Original Message-----
xl2000
My formula works fine but it has the #value! error. what
do I add to my
formula to rid myself of this?

=IF(C37+D37,C37+D37,"")+D36*D35

Thanks
.

Tried your Debras solve and I still have the error without data, entered data
just to checK it and it does work. Any other ideas

"Biff" wrote:

Hi!

Replace the "" with a zero.

BTW, if your formula returns a #VALUE! error, it's not
working fine. <g

Biff

-----Original Message-----
xl2000
My formula works fine but it has the #value! error. what
do I add to my
formula to rid myself of this?

=IF(C37+D37,C37+D37,"")+D36*D35

Thanks
.

If Debra's formula gives you an error you must have formula blanks or spaces
in the cells when they look empty
there is no way that formula can give an error on empty cells

another way

=SUM(C37:D37,IF(OR(D36="",D35=""),0,D36*D35))

change "" to space if that's what you have

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Mike R" wrote in message
...
Tried your Debras solve and I still have the error without data, entered
data
just to checK it and it does work. Any other ideas

"Biff" wrote:

Hi!

Replace the "" with a zero.

BTW, if your formula returns a #VALUE! error, it's not
working fine. <g

Biff

-----Original Message-----
xl2000
My formula works fine but it has the #value! error. what
do I add to my
formula to rid myself of this?

=IF(C37+D37,C37+D37,"")+D36*D35

Thanks
.

Thank you so much for your input!!! I found the space and all is well now!!!
Sometimes the right information at the right time is all it takes.

"Peo Sjoblom" wrote:

If Debra's formula gives you an error you must have formula blanks or spaces
in the cells when they look empty
there is no way that formula can give an error on empty cells

another way

=SUM(C37:D37,IF(OR(D36="",D35=""),0,D36*D35))

change "" to space if that's what you have

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Mike R" wrote in message
...
Tried your Debras solve and I still have the error without data, entered
data
just to checK it and it does work. Any other ideas

"Biff" wrote:

Hi!

Replace the "" with a zero.

BTW, if your formula returns a #VALUE! error, it's not
working fine. <g

Biff

-----Original Message-----
xl2000
My formula works fine but it has the #value! error. what
do I add to my
formula to rid myself of this?

=IF(C37+D37,C37+D37,"")+D36*D35

Thanks
.