concatenate IF formula error

[polyocho]

I am trying to use a concatenate if text is present but the text to display if value is false is not appearing correctly. Can someone tell me how to correct my formula?

F8 has multiple data about how peaches feels (ie happys, sad, mad etc). If this is not blank then I would like to have G8 concatenate this with the statement "peaches feels". However, if F8 is blank then I would like nothing to be displayed in G8. My formula is failing and I am not sure why and I have tried inserting "" to define the false argument in multiple places but when F8 is blank G8 still says "Peaches feels"

=IF(ISTEXT(F8),CONCATENATE("Peaches feels ",F8), " ")

I have also tried

=IF(ISTEXT(F8),CONCATENATE("The symptoms do not occur on ","",F8,""),"")

any suggestions?

Thank you in advance.

 

[JoeMo]

Try:
=IF(F8="","","Peaches feels "&F8)

 

[Rick Rothstein]

I am trying to use a concatenate if text is present but the text to display if value is false is not appearing correctly. Can someone tell me how to correct my formula?

F8 has multiple data about how peaches feels (ie happys, sad, mad etc). If this is not blank then I would like to have G8 concatenate this with the statement "peaches feels". However, if F8 is blank then I would like nothing to be displayed in G8. My formula is failing and I am not sure why and I have tried inserting "" to define the false argument in multiple places but when F8 is blank G8 still says "Peaches feels"

=IF(ISTEXT(F8),CONCATENATE("Peaches feels ",F8), " ")

I have also tried

=IF(ISTEXT(F8),CONCATENATE("The symptoms do not occur on ","",F8,""),"")

any suggestions?

Try it like this instead...

=IF(F8="","",CONCATENATE("Peaches feels ",F8))

Although I like to concatenate text using the ampersand instead of the CONCATENATE function...

=IF(F8="","","Peaches feels "&F8)

 

[polyocho]

Thank you. This worked real well!