Quotes in Formula

  • Thread starter Thread starter monagan
  • Start date Start date
M

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
 
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?
 
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?
 
Back
Top