IF(sheet.1!prop.something=tekst

[cbrandy]

Hi all.
I'm stuck with a problem. I have this input that can be 2 things.

1 Tag=323
2 Tag=U323

ex.
IF(sheet.1!prop.Tag<>"", "+"&Tag,"")

When I do this, I get nr 1, but when I use nr 2, I get this wrong.
Can anyone help me with this?

-Andy

[Yacine]

use "not(strsame(..)" instead of "<>"

[vojo]

user.tag = "U323"

if(not(strsame(sheet.1!prop.tag, "")), "+"&user.tag,"")

or

if(not(strsame(sheet.1!prop.tag,"")),"+"&"U323","")



though not sure why you would just want to do this   U323 ==> +U323
What does the + do for you?

I think you really want to do this

sheet.1!user.tag = "U323"
sheet.1!prop.tag ="really cool tag "

if(not(samestr(sheet.1!prop.tag, "")), sheet.1!prop.tag+" + "+sheet.1!user.tag,"")
gives  "really cool tag + U323"