IF Clause

D

dpal

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"MAPLE_A3"),20.75,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.
 
B

Bernard Liengme

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
 
D

dpal

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
 
D

dpal

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?
 
P

Peo Sjoblom

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
 
Top