'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.

'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.

'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
?

'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
?

'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
?