ExcelBanter - Help wit text in formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help wit text in formula (https://www.excelbanter.com/excel-discussion-misc-queries/32990-help-wit-text-formula.html)

Glen

Help wit text in formula

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" 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

Glen

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

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

All times are GMT +1. The time now is 09:08 PM.