Quotes in Formula

[monagan]

I have a formula like...

IF(A1=5,6",20")

-if a1 is 5, then cell displays 6"
if not, then it displays 20"

Excel thinks I am missing quotes. How to I get the inch marks to be i
there and still have the formula work

 

[RagDyeR]

Try this:

=IF(A1=5,6&"""",20&"""")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a formula like...

IF(A1=5,6",20")

-if a1 is 5, then cell displays 6"
if not, then it displays 20"

Excel thinks I am missing quotes. How to I get the inch marks to be in
there and still have the formula work?

 

[RagDyeR]

A little simpler:

=IF(A1=5,"6""","20""")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Try this:

=IF(A1=5,6&"""",20&"""")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a formula like...

IF(A1=5,6",20")

-if a1 is 5, then cell displays 6"
if not, then it displays 20"

Excel thinks I am missing quotes. How to I get the inch marks to be in
there and still have the formula work?