Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'If' with text values
Hello All,
I think my pascal background is hampering me here. All I need to do is is this - If the numercial value in A1 is 1 then make the text value in A2 'hello' If the numercial value in A1 is 2 then make the text value in A2 'goodbye' I have the structure but just can't get the syntax correct - can anyone help please? Thanks Liam. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
'If' with text values
=if(A1=1,"Hello",if(A1=2,"Goodbye",""))
-- Regards, Tom Ogilvy "Liam" wrote in message ups.com... Hello All, I think my pascal background is hampering me here. All I need to do is is this - If the numercial value in A1 is 1 then make the text value in A2 'hello' If the numercial value in A1 is 2 then make the text value in A2 'goodbye' I have the structure but just can't get the syntax correct - can anyone help please? Thanks Liam. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
'If' with text values
Thanks Tom, Sorry I wan't clear enough!
There are a whole bunch of possible values and outcomes, way too many for a nested IF statement approach. I was looking for a VB solution something along the lines of Case or If ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
'If' with text values
Try
=CHOOSE(H1,"A","B","C","D") just extend the list as needed. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Liam" wrote in message oups.com... Thanks Tom, Sorry I wan't clear enough! There are a whole bunch of possible values and outcomes, way too many for a nested IF statement approach. I was looking for a VB solution something along the lines of Case or If ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
'If' with text values
Easier to create a table of numbers in the left column and results in the
right column, then use =if(A1="","",vlookup(A1,Sheet2!A1:B1000,2,False)) Otherwise Select Case Range("A1").Value Case 1 res = "Hello" Case 2 res = "Goodbye" Case Else res = "Not found" End Select Case msgbox Res -- Regards, Tom Ogilvy "Liam" wrote in message oups.com... Thanks Tom, Sorry I wan't clear enough! There are a whole bunch of possible values and outcomes, way too many for a nested IF statement approach. I was looking for a VB solution something along the lines of Case or If ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to values | Excel Worksheet Functions | |||
Sumif using Values, but returning text or values | Excel Discussion (Misc queries) | |||
Plotting XY with X text values? Credit ratings and their ROE values | Charts and Charting in Excel | |||
Finding values within text and substituting with alternate values. | Excel Programming | |||
Text values to numeric values | Excel Discussion (Misc queries) |