Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel check value i cell
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 ! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel check value i cell
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' 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel check value i cell
On Tuesday, February 19, 2013 1:48:52 PM UTC+1, Claus Busch wrote:
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' 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 hmmm... Excel sais : ''formula error'' |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel check value i cell
On Tuesday, February 19, 2013 11:15:22 PM UTC-8, Marin wrote:
On Tuesday, February 19, 2013 1:48:52 PM UTC+1, Claus Busch wrote: 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' 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 hmmm... Excel sais : ''formula error'' 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel check value i cell
On Wednesday, February 20, 2013 12:01:41 PM UTC+1, wrote:
On Tuesday, February 19, 2013 11:15:22 PM UTC-8, Marin wrote: On Tuesday, February 19, 2013 1:48:52 PM UTC+1, Claus Busch wrote: 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' 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 hmmm... Excel sais : ''formula error'' 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 iam from Croatia, EU. so maybe problem is cause regional setting... who knows anyway, thank you guys so much |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel check value i cell
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 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel check value i cell
On Wednesday, February 20, 2013 5:17:09 PM UTC+1, Claus Busch wrote:
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 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 yes! thing is working i import this: =CHOOSE(LEFT(A2;4)-3009;"Street";"Block";"Town") thx once again. iam so happy now |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
DataValidation Check in cell of excel | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
'CHECK IF A CELL IN EXCEL HAS ANY TEXT IN IT' | Excel Worksheet Functions |