Using OR syntax

[shaibn]

I am trying to use the following OR syntax:

=if(or(b2="RW","MW","WZ","WZk","Expenditure","Income"))

where is B2 I have one of the values noted in the brackets. For some reason I get an error for the OR syntax.

Please assist.

Thanks,
Shai

[shukla.ankur281190]

perhaps

=IF(OR(B2={"RW","MW","WZ","WZk"}),"Expenditure","Income")

[shaibn]

It gives me the "Income" rather than "Expenditure", although in cell B2 I have a value of "RW".

[shukla.ankur281190]

But it is working here ok. Do check again

[Special-K]

You've may have a space or CHR(160) in B2, henc "RW " does not equal "RW"

in a blank cell enter
=(B2="RW")
If it says FALSE then B2 is definitely not "RW"

[shaibn]

I have no left space, and it still does not work.

[shukla.ankur281190]

Please provide spreadsheet

[Oppressed1]

What shukla said - all 3 times. And adding to Special-K, a technique I use is something like
a5=1
a6=a5+1
a7=a6+1
etc., copied down

b5=code(mid($B$2,a5,1))
and copy down
Then at least I see the true ASCII content of B2. Sometimes it awakens me to the letter 'ell' (l) vs. one(1), or 0 vs. O, etc.

[Khalidngo]

Hi shaibn,

Perhaps you need wildcard:
=IF(SUM(COUNTIF(B2,"*"&{"RW","MW","WZ","WZk"}&"*")),"Expenditure","Income")

or with simplified:
=SIGN(SUM(COUNTIF(B2,"*"&{"RW","MW","WZ","WZk"}&"*")))

Format the cell as:
"Expenditure";;"Income"

Blessing