IF Clause
 

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.

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.

IF Clause
 

try "1/2""maple"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

IF Clause
 

yes I tried that and it didn't work the other one I tried was
"1/2"""maple".No luck either
1/2"Maple_A3 is in cell A1, and 20.75 is in cell A2

"Don Guillett" wrote:

try "1/2""maple"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

IF Clause
 

Try


"1/2""MAPLE_A3"



--
Regards,

Peo Sjoblom



"dpal" wrote in message
...
yes I tried that and it didn't work the other one I tried was
"1/2"""maple".No luck either
1/2"Maple_A3 is in cell A1, and 20.75 is in cell A2

"Don Guillett" wrote:

try "1/2""maple"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

IF Clause
 

"1/2"maple_a3"
just add the extra "
"1/2""maple_a3"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dpal" wrote in message
...
yes I tried that and it didn't work the other one I tried was
"1/2"""maple".No luck either
1/2"Maple_A3 is in cell A1, and 20.75 is in cell A2

"Don Guillett" wrote:

try "1/2""maple"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

IF Clause
 

Thanks, Neither worked. I could enter the extra " on the first argument but
had to enter double " " on the second for it to except it. Still comes up
False.

I tried something else but only one argument works not the other.


=IF(A10=MID(A5,5+6,0),B5,IF(A10=RIGHT(A6,5+6),B6))

A5 = 1/2"MAPLE_A3 B5 = 20.75
A6 = 1/2"MDF B6 = 6

WHEN I PUT 1/2"MDF IN A10 IT COMES UP 6 , But when I put in 1/2"MAPLE_A3 it
comes up false.
any thoughts on this one?


"Don Guillett" wrote:

"1/2"maple_a3"
just add the extra "
"1/2""maple_a3"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dpal" wrote in message
...
yes I tried that and it didn't work the other one I tried was
"1/2"""maple".No luck either
1/2"Maple_A3 is in cell A1, and 20.75 is in cell A2

"Don Guillett" wrote:

try "1/2""maple"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

IF Clause
 

1. Your mid formula is incorrect and will return a blank, thus it won't
match any text string in A10, thus the FALSE, secondly you should put
something if neither values match (that is why you are getting FALSE if
neither is a match). Having said that I don't know what you are doing wrong
since this works for me using your example and it will match the criteria
and returns the correct answers if I put those values in A10

=IF(A10="1/2""MAPLE_A3",B5,IF(A10="1/2""MDF",B6,"Neither"))

if that does not work for you I can only assume you have leading or trailing
spaces or other invisible characters in A10

--
Regards,

Peo Sjoblom



"dpal" wrote in message
...
Thanks, Neither worked. I could enter the extra " on the first argument
but
had to enter double " " on the second for it to except it. Still comes
up
False.

I tried something else but only one argument works not the other.


=IF(A10=MID(A5,5+6,0),B5,IF(A10=RIGHT(A6,5+6),B6))

A5 = 1/2"MAPLE_A3 B5 = 20.75
A6 = 1/2"MDF B6 = 6

WHEN I PUT 1/2"MDF IN A10 IT COMES UP 6 , But when I put in 1/2"MAPLE_A3
it
comes up false.
any thoughts on this one?


"Don Guillett" wrote:

"1/2"maple_a3"
just add the extra "
"1/2""maple_a3"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dpal" wrote in message
...
yes I tried that and it didn't work the other one I tried was
"1/2"""maple".No luck either
1/2"Maple_A3 is in cell A1, and 20.75 is in cell A2

"Don Guillett" wrote:

try "1/2""maple"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

IF Clause
 

I got it to work. I had extra () in there.

Thanks

"Peo Sjoblom" wrote:

1. Your mid formula is incorrect and will return a blank, thus it won't
match any text string in A10, thus the FALSE, secondly you should put
something if neither values match (that is why you are getting FALSE if
neither is a match). Having said that I don't know what you are doing wrong
since this works for me using your example and it will match the criteria
and returns the correct answers if I put those values in A10

=IF(A10="1/2""MAPLE_A3",B5,IF(A10="1/2""MDF",B6,"Neither"))

if that does not work for you I can only assume you have leading or trailing
spaces or other invisible characters in A10

--
Regards,

Peo Sjoblom



"dpal" wrote in message
...
Thanks, Neither worked. I could enter the extra " on the first argument
but
had to enter double " " on the second for it to except it. Still comes
up
False.

I tried something else but only one argument works not the other.


=IF(A10=MID(A5,5+6,0),B5,IF(A10=RIGHT(A6,5+6),B6))

A5 = 1/2"MAPLE_A3 B5 = 20.75
A6 = 1/2"MDF B6 = 6

WHEN I PUT 1/2"MDF IN A10 IT COMES UP 6 , But when I put in 1/2"MAPLE_A3
it
comes up false.
any thoughts on this one?


"Don Guillett" wrote:

"1/2"maple_a3"
just add the extra "
"1/2""maple_a3"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dpal" wrote in message
...
yes I tried that and it didn't work the other one I tried was
"1/2"""maple".No luck either
1/2"Maple_A3 is in cell A1, and 20.75 is in cell A2

"Don Guillett" wrote:

try "1/2""maple"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.