Thread: IF Clause
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default IF Clause

If A1 has a double quote (nothing to do with inches!) within its text such
as: a"b
and I want to see if the content of A1 is (a"b) then I use the formula
=A1="a""b"

Note that to indicate I mean an included quote I use a pair of quotes.
So you would use 1/2""MAPLE_A3
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dpal" wrote in message
...
Hello,
I am trying to use a if phase but my variable has the inches quotation in
it
( " ). I think it doesn't recognize this. What can I do. I have to change
to
many things if I was to take this out.
ex: ,IF((L_END_FIN@"="1/2"MDF),6)).
My problem is when it looks for the 1/2"MAPLE_A3 OR 1/2"MDF it doesn't
recognize it.

Any thoughts.