if function returning 0 when it should not

My formula is:

=IF(SUM($E$7:$G$7)=0,HLOOKUP(LARGE($B7:$D7,1),$B7:$D7,1,FALSE),"sweet")

I can't figure out why the above formula keeps returning a zero. Shouldn't it return the HLOOKUP value? I used the "Evaluate Formula" Excel feature, and everything looks good, up to the point of getting a "0," i.e., =IF(TRUE,94,"sweet"). I even pulled the HLOOKUP function out of the formula to test it, and it worked properly. I mean, shouldn't it return the value "94," instead of "0"?

What am I doing wrong?

Thanks in advance,
Scientia

Either The sum value of the range may be zero or the range values are text data.

Originally Posted by :) Sixthsense :)

Either The sum value of the range may be zero or the range values are text data.

Thanks for the quick response! You are correct that the sum value of the range is zero, but why does that matter? I thought that would yield the "True" value of the IF function... ?

I believe the formula is working fine both If and Hlookup the reason for zero result is the Hlookup result is blank and that is the reason the Hlookup is returning the value 0 instead of "". That is how the vlookup and hlookup works.