Excel check value i cell

  • Thread starter Thread starter Marin
  • Start date Start date
M

Marin

Dear Sirs,
I do not know how to solve a problem with excel. I want to check the value in cell 'A2' (3010-401/15/2013). if 'A2' has 3010 then in 'B2' should be 'street', if it has 3011, should then be 'block', if the 3012, it should be a 'town'

thanks in advance !
 
Hi,

Am Tue, 19 Feb 2013 03:56:27 -0800 (PST) schrieb Marin:
I do not know how to solve a problem with excel. I want to check the value in cell 'A2' (3010-401/15/2013). if 'A2' has 3010 then in 'B2' should be 'street', if it has 3011, should then be 'block', if the 3012, it should be a 'town'
Click to expand...

try:
=CHOOSE(LEFT(A2,4)-3009,"Street","Block","Town")


Regards
Claus Busch
 
Hi,



Am Tue, 19 Feb 2013 03:56:27 -0800 (PST) schrieb Marin:






try:

=CHOOSE(LEFT(A2,4)-3009,"Street","Block","Town")





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2
Click to expand...

hmmm...
Excel sais : ''formula error''
 
hmmm...

Excel sais : ''formula error''
Click to expand...

I tried the formula Claus offered and this one by Ben in the .Programming forum.
Both worked for me, using Excel2010.

=CHOOSE(1+MID(A2, 4, 1), "street", "block", "town")

Howard
 
I tried the formula Claus offered and this one by Ben in the .Programming forum.

Both worked for me, using Excel2010.



=CHOOSE(1+MID(A2, 4, 1), "street", "block", "town")



Howard
Click to expand...

iam from Croatia, EU.
so maybe problem is cause regional setting... who knows

anyway, thank you guys so much
 
Hi Marin,

Am Wed, 20 Feb 2013 08:04:55 -0800 (PST) schrieb Marin:
iam from Croatia, EU.
so maybe problem is cause regional setting... who knows
Click to expand...

it could be the separator. Change the commas to semikolons.
Does it work?


Regards
Claus Busch
 
Hi Marin,



Am Wed, 20 Feb 2013 08:04:55 -0800 (PST) schrieb Marin:







it could be the separator. Change the commas to semikolons.

Does it work?





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2
Click to expand...

yes!
thing is working
i import this:
=CHOOSE(LEFT(A2;4)-3009;"Street";"Block";"Town")

thx once again. iam so happy now
 
Back
Top