Cell has added text to data, need to be blank if no data.

[Fety]

I have a cell that shows data from 2 cells in another sheet. In that cell I have it showing the words Port and then data from C1 and then a - and then the data from F1.

Here's the formula:

="Port "&'Sheet 4'!C1 &"-"&'Sheet 4'!F1


If the cells in C1 and F1 are blank, it just shows: Port - ....I want it to display nothing if both of those cells are blank.

Also, if possible, I would like it to just display the port number from F1 with no - if C1 is blank.

Thanks in advance!!

[Lemice]

Hello,

You can add an isblank formula before yours.
So it might be like this:
=IF(AND(ISBLANK(C1),ISBLANK(F1)),"",IF(ISBLANK(C1),"Port "&'Sheet 4'!F1,"Port "&'Sheet 4'!C1-""&'Sheet 4'!F1))

Hope this help.

[Fety]

For some reason this isn't showing anything in the cell when I enter it in. Let me remind you the data is coming from Sheet 4, ....So shouldn't all the instances of C1 and F1 have 'Sheet 4' in front of it? I am a complete novice with formulas!

[Lemice]

Yes, you are right, it's my bad
The formula should look like this

Please Login or Register  to view this content.

[Fety]

For some reason that still didn't quite work, it would show the #VALUE in the cell. But I had a friend help me with it and he said it just needed to be shortened to this....

Please Login or Register  to view this content.

Thanks again for your help!