Hi,

Maybe this is what you're looking for:

=IF(B1="Hi","Hello",IF(B1="Bye","Good Bye",""))

HTH
Jean-Guy

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