'If' with text values

[Liam]

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.

 

[Tom Ogilvy]

=if(A1=1,"Hello",if(A1=2,"Goodbye",""))

 

[Liam]

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
?

 

[Bob Phillips]

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)

 

[Tom Ogilvy]

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