Mandy_
asked on
excel If Statement is false but value is true
Dear experts,
in the formula below i'm getting "false" but in worksheet IMPORT!Q2 the value is web-only-user
Whats the problem?
in the formula below i'm getting "false" but in worksheet IMPORT!Q2 the value is web-only-user
Whats the problem?
=IF(IMPORT!Q2="web-only-user";"Set-CASMailbox -Identity "&A2&" -PopEnabled $false -ImapEnabled $false -ActiveSyncEnabled $false -MAPIBlockOutlookRpcHttp $true -MAPIEnabled $true -OwaMailboxPolicy $null"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What does this give?
and
="+" & import!q2 & "+"
and
=len(import!q2)
There are actually two different ascii characters for a symbol that looks like '-'. I can't remember the actual codes off hand, but try re-typing Q2 and then type the formula with exactly the same key choice.
ASKER
"+web-only-user+"
and
=len(import!q2)
empty cell
and
=len(import!q2)
empty cell
Those two answers are so strange - can you please post your spreadsheet.
ASKER
if i change web-only-user to "web" in import!q2 everything working fine. Thats an issue with "-"
Got it! (I think)
Change
=IF(IMPORT!Q2="web-only-us er";
to =IF(IMPORT!Q2="web-only-us er",
It should be a comma, not a semi-colon.
Trouble is, your initial formula won't actually work, so if this doesn't work, we are a little in the dark helping you. So please then post your spreadsheet.
Change
=IF(IMPORT!Q2="web-only-us
to =IF(IMPORT!Q2="web-only-us
It should be a comma, not a semi-colon.
Trouble is, your initial formula won't actually work, so if this doesn't work, we are a little in the dark helping you. So please then post your spreadsheet.
ASKER
if i change q2 and type web-only-user it's also working. The data in this column are coming from powershell.
and if we search in the formula for "web" in q2?
and if we search in the formula for "web" in q2?
I doubt the semi-colon is the issue. You can change the standard delimiter and some regions have the semi colon as standard.
I refer to my previous post. The issue looks like the ascii character used to do the hyphen (or the minus). There are at least two different possibility within the standard ascii set.
I refer to my previous post. The issue looks like the ascii character used to do the hyphen (or the minus). There are at least two different possibility within the standard ascii set.
Please post your spreadsheet. There's nothing more I can help you with unless you do so.
When typing your formula, instead of hitting the hyphen, instead hit ALT+196 and see if that works.
ASKER
My fault! the CSV was written in ACSII Encoding. I changed to default and now all working fine.
Thank you so much for your help!
Thank you so much for your help!
ASKER
but the value in IMPORT!Q2 excactly is web-only-user
$null","") not working
$null""") shows false
and
$null";"") shows empty cell
???