Cell references

%3CLINGO-SUB%20id%3D%22lingo-sub-1728909%22%20slang%3D%22en-US%22%3ECell%20references%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728909%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20a%20column%2C%20I%20am%20referencing%20cells%20on%20another%20sheet%20of%20the%20same%20book.%20If%20there%20is%20no%20data%20in%20the%20cells%20that%20are%20being%20referenced%2C%20I%20get%20a%200%20returned.%20How%20can%20I%20make%20this%20blank%3F%3C%2FP%3E%3CP%3Ei.e.%3C%2FP%3E%3CP%3E%3DDetails!C11%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1728909%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728953%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20references%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728953%22%20slang%3D%22en-US%22%3EIn%20the%20other%20sheet%2C%20enter%20this%20formula%3CBR%20%2F%3E%3DIF('sheet1'!A1%3D%22%22%2C%22%22)%3C%2FLINGO-BODY%3E
Highlighted
Visitor

In a column, I am referencing cells on another sheet of the same book. If there is no data in the cells that are being referenced, I get a 0 returned. How can I make this blank?

i.e.

=Details!C11

 

1 Reply
Highlighted

In Sheet2, enter this formula =IF('Details'!C11:C20="","")

 

You can copy down the formula using fill handle

 

For the IF False, you can put in whatever result you wanna see if the logical test is false