Writing formula to include quote marks in result
 

I have an if/then formula that depending on the contents of a cell I want it
to return one of 3 results. The formula works fine, except I want part of
the text result in quotation marks:

Col "M"
Col "N"

etc. Normal thinking in the formula puts it as
,"Col "M"","Col "N""

but this does not work. Any suggestions? Thanks in advance!

Writing formula to include quote marks in result
 

"Col ""M"""

--
__________________________________
HTH

Bob

"Valerie" wrote in message
...
I have an if/then formula that depending on the contents of a cell I want
it
to return one of 3 results. The formula works fine, except I want part of
the text result in quotation marks:

Col "M"
Col "N"

etc. Normal thinking in the formula puts it as
,"Col "M"","Col "N""

but this does not work. Any suggestions? Thanks in advance!

Writing formula to include quote marks in result
 

Try it like this:

=IF(.....,"Col ""M""","Col ""N""")

--
Biff
Microsoft Excel MVP


"Valerie" wrote in message
...
I have an if/then formula that depending on the contents of a cell I want
it
to return one of 3 results. The formula works fine, except I want part of
the text result in quotation marks:

Col "M"
Col "N"

etc. Normal thinking in the formula puts it as
,"Col "M"","Col "N""

but this does not work. Any suggestions? Thanks in advance!

Writing formula to include quote marks in result
 

Perfect!! Thanks!!!! You guys are life-savers!

"T. Valko" wrote:

Try it like this:

=IF(.....,"Col ""M""","Col ""N""")

--
Biff
Microsoft Excel MVP


"Valerie" wrote in message
...
I have an if/then formula that depending on the contents of a cell I want
it
to return one of 3 results. The formula works fine, except I want part of
the text result in quotation marks:

Col "M"
Col "N"

etc. Normal thinking in the formula puts it as
,"Col "M"","Col "N""

but this does not work. Any suggestions? Thanks in advance!

Writing formula to include quote marks in result
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Valerie" wrote in message
...
Perfect!! Thanks!!!! You guys are life-savers!

"T. Valko" wrote:

Try it like this:

=IF(.....,"Col ""M""","Col ""N""")

--
Biff
Microsoft Excel MVP


"Valerie" wrote in message
...
I have an if/then formula that depending on the contents of a cell I
want
it
to return one of 3 results. The formula works fine, except I want part
of
the text result in quotation marks:

Col "M"
Col "N"

etc. Normal thinking in the formula puts it as
,"Col "M"","Col "N""

but this does not work. Any suggestions? Thanks in advance!