You tested for only Y when there are several other possibilities.
Wade
Franz Wein wrote:
Hello together
Semicolon or comma - this is also a matter of discontinued language in
the document
In German, the separator always is between the blocks a ";" in the
English-language versions a ","
But I have another others resolution: (separator is this ";", because I
installed the German version).
Instead of this
=WENN(ODER(A1="y";A1="yellow";A1="Y";A1="Yellow");5;0)
it can also be written:
=WENN(GROSS(TEIL(A1;1;1))="Y";5;0)
in words: if the upper first character "Y" in cell A1, then 5 else 0.
best regards
Franz
Wade Smart schrieb:
Ok. This is weird. I was playing around with this wondering what is
wrong. I copied and pasted Anthony posted and it didnt work. I screwed
up and and hit delete before I could make a change so I did it again.
I copied and pasted his example but, I picked the wrong one.
=IF( OR(F6="yellow",F6="y",F6="Yellow",F6="Y") ,5,0)
I didnt even notice it until I hit Enter on the keyboard that 5 came up.
But if you notice, the "," are present not ";". Now, if you look at
any other posts I have made its been clear that ";" is what works on
my build.
No idea at all what has happened here but, it is working.
Wade
Wade Smart wrote:
Here is what I used:
=IF(OR(F6="yellow";F6="y");5;0)
Note: I did changed from F8 to F6 to test.
Wade
Johnny Rosenberg wrote:
2010/1/28 Wade Smart <[email protected]>:
I still get a 508 error using it.
Error 508 means that parentheses don't match and shouldn't have
anything to do with comparing strings. Check again that you didn't
type one parenthesis too many or if you missed one.
Regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
