You can't add two text strings together - use & instead of + between
the two If statements.

Hope this helps.

Pete


On Feb 14, 3:22 pm, Nater wrote:
I'm trying to enter a formula similar to
=IF(B1=0,"0")+IF(B1=1,A1*1)+IF(B1=2,A1*2)
but instead of A1*1 or 2 etc. I want the result to return a text response
such as
=IF(B1="Hi","Hello")+IF(B1="Bye","Good bye") but this results in an error.
What am I doing wrong?