Help wit text in formula

[Glen]

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

 

[Kassie]

Hi Glen

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

 

[Glen]

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

 

[Dave Peterson]

Try posting the formula you actually use.

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