Try posting the formula you actually use.

Copy it from the formulabar and paste it in your next post.

Glen wrote:

Tried that and still get the same error that some is wrong with "he"

"Kassie" wrote:

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

--

Dave Peterson