Need Cell to stay empty if a function = 0

Hello, I am setting up a sheet that auto adds names from fields on another sheet, but in no name is entered, then I get "0". How can I make the cell stay blank if no name is entered on the other sheet?

Thanks for any help you can provide.

Originally Posted by Lesbrewer

Hello, I am setting up a sheet that auto adds names from fields on another sheet, but in no name is entered, then I get "0". How can I make the cell stay blank if no name is entered on the other sheet?

Thanks for any help you can provide.

try following

IF(cell="","",your_formula)

"cell" is the cell where you enter names.

let me know if you could able to chack it out.

Originally Posted by starguy

try following

IF(cell="","",your_formula)

"cell" is the cell where you enter names.

let me know if you could able to chack it out.

I tried it out and I could not get it to work.

This is what I need it to do:

I have 2 sheets. One is named Labor and Loading Worksheet, the other sheet is the Cover Sheet. I want to be able to just type in the Names once on the Labor and Loading Worksheet and have the info go over to the Cover sheet. Both Sheets are forms that I need to print out for the job and I have 5 spaces for the members of the crew to be listed. If I only use 3, I would like for the other 2 spaces to be empty. I get "0" on the cover sheet part, if nothing is put into the Labor and Loading Worksheet.

This is what I am using now:
='Labor and Loading Worksheet'!B11

Cell B11 on the "Labor and Loading Worksheet" has "John Smith"
On the "Cover Sheet" it = "John Smith"
If nothing is input on B11, on the "Labor and Loading Workseet", 0 shows up on the "Cover Sheet".

Originally Posted by Lesbrewer

I tried it out and I could not get it to work.

This is what I need it to do:

I have 2 sheets. One is named Labor and Loading Worksheet, the other sheet is the Cover Sheet. I want to be able to just type in the Names once on the Labor and Loading Worksheet and have the info go over to the Cover sheet. Both Sheets are forms that I need to print out for the job and I have 5 spaces for the members of the crew to be listed. If I only use 3, I would like for the other 2 spaces to be empty. I get "0" on the cover sheet part, if nothing is put into the Labor and Loading Worksheet.

This is what I am using now:
='Labor and Loading Worksheet'!B11

Cell B11 on the "Labor and Loading Worksheet" has "John Smith"
On the "Cover Sheet" it = "John Smith"
If nothing is input on B11, on the "Labor and Loading Workseet", 0 shows up on the "Cover Sheet".

try this
=IF(Labor and Loading Worksheet!B11="","",Labor and Loading Worksheet!B11)

Regards