#VALUE! error

[qamarkhan]

Hello New in this Forum
I have error #VALUE!

Cell B4 have Vlookup formula
Cell G4 have if formula IF(B4>0,B4+C4+D4+E4,0)
When B4 has no value, then I get #VALUE! error.

Same H4 have formula (B4*40%)+B4+C4+D4
When B4 has no value, then I get #VALUE! error.

Same I4 Have formula B4+H4
When B4 has no value, then I get #VALUE! error.

Please help me to solve this error

Thanks in advance

[benishiryo]

welcome to the forum. i am guessing your VLOOKUP formula shows a blank or error when you say "no value"? it wouldnt be a problem if B4 is a number. so to counter that, use SUM (sum ignores text) instead of "+". "+" cannot add texts:
=IF(B4>0,SUM(B4:E4),0)

otherwise, just cover it with an IFERROR:
=IFERROR(IF(B4>0,B4+C4+D4+E4,0),"")

=IFERROR(B4*40%+B4+C4+D4,"")

=IFERROR(B4+H4,"")

do upload an excel sample so that we do not have to manually key in your data to do a testing.

input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

hopefully, i did a correct guess. otherwise, it's wasted effort coming up with something that does not help you. if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong

[6StringJazzer]

The formula in B4 is important but you didn't include that.

What does "B4 has no value" mean? VLOOKUP either returns a value, or an error. Do you mean it returns an error?

What result do you want in G4, H4, I4 if B4 has no value?

I think you want something like this in B4. If VLOOKUP returns an error, the B4 will be 0:

=IFERROR(current vlookup formula, 0)

[qamarkhan]

Thank you benishiryo
my error problem is solved with your formula suggestions.

Thanks again