=IF(B8="M","HI") OK but =IF(B8="M","HI")+IF(B8="x","bye") not why

N

Nater

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

Dave F

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

This assumes that the only two possible values in B1 are "hi" or "bye".

Dave
 
P

Pete_UK

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

Hope this helps.

Pete
 
D

Don Guillett

try this idea
=if(b1=0,"joe","")&if(b2=1," played","")
but maybe you just want to nest em
if(b1=0,dothis,if(b1=1,dothat,""))
 
P

pinmaster

Hi,

Maybe this is what you're looking for:

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

HTH
Jean-Guy
 
Top