Nested IF Statement Formula Works, if conditions aren't met I get a #VALUE! instead of 0/Blank

[c.clavin]

Hi guys, I've been trying to refigure this for a while but can't seem to get it. The formula works when the cells referenced have data in them, but when its blank, I get a #VALUE! result which is affecting the rest of my calculation down the column. Can you help? Basically adding up to 3 numbers, out of 4 total statements. Thanks

=SUM(IF(H21="","",VLOOKUP(H21,FRUITS,2,FALSE)),IF(AND(ISNUMBER(SEARCH("Apple",H17)),ISNUMBER(SEARCH("Orange",H21))),J32,0),IF(AND(H17="",ISNUMBER(SEARCH("Orange",H21))),K32,0),IF(AND(H17="",I21="Delivery"),93,0))

 

[c.clavin]

Should I have started it with a blank/non blank if statement? Like =IF(H21="","",SUM... ?

 

[jtakw]

Hi,

Don't know anything about your data, but may be you can just wrap your formula with IFERROR, like:

=IFERROR(your formula,"")

 

[jmenzel30]

Hi,

Don't know anything about your data, but may be you can just wrap your formula with IFERROR, like:

=IFERROR(your formula,"")

I'm having this same issue. I attempted your solution and it did indeed get rid of the error. But the other issue I'm having is that I'm charting this data. So the chart is still plotting 0's and displaying them in the line graph.