Help with #VALUE!

[alfonso101]

Dear Friends,

I have the following formula in cell H4
=IF(((F3-(C3+E3))>=0),"Yes","No")

Can someone help me to eliminate the #VALUE! response for cell without data?

Thanks

[alansidman]

Wrap the functions in the Iferror function. See attached.

[:) Sixthsense :)]

May be this...

In H3 Cell

Please Login or Register  to view this content.

Drag it down...

[xwarlock10x]

just put this in cell H3 then copy down..

=IFERROR(IF(((F3-(C3+E3))>=0),"Yes","No"),"")

and in J3
=IFERROR(F3-(C3+E3),"")

and in M3
=IFERROR(IF(((K3-(C3+E3))>=0),"Yes","No"),"")

[alfonso101]

THANKS...!
It works great