Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create and save a formula for text fields? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Coverting Formula to Text | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |