Hi Glen

You should enclose the text in ""'s, eg IF(D6="HE",.......

"Glen" wrote:

I have a IF statement Ex. if(D6=HE),sum(f6,g4)) and I get an error on HE what
am I doing wrong. help with the correct formula. Thanks