Home

Excel Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-736838%22%20slang%3D%22en-US%22%3EExcel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736838%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20Im%20trying%20to%20use%20this%20formula%26nbsp%3B%3D('Data%20Entry'!B34)%20to%20retrieve%20data%20from%20another%20part%20of%20the%20spreadsheet%2C%20but%20if%20the%20cell%20is%20blank%20it%20give%20me%20a%20Zero%20in%20the%20cell.%26nbsp%3B%20How%20do%20i%20get%20this%20to%20show%20a%20blank%20instead%20when%20there%20is%20no%20data%20in%20the%20field%20im%20retrieving%20from.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EMark%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-736838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736880%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736880%22%20slang%3D%22en-US%22%3EModify%20your%20formula%20like%20this%3A%3CBR%20%2F%3E%3DIF(%E2%80%98Data%20Entry%E2%80%99!B34%3D%E2%80%9C%E2%80%9D%2C%3CBR%20%2F%3E%E2%80%9C%E2%80%9D%2C%3CBR%20%2F%3E%E2%80%98Data%20Entry%E2%80%99!B34)%3C%2FLINGO-BODY%3E
Highlighted
markS160
Occasional Visitor

HI Im trying to use this formula =('Data Entry'!B34) to retrieve data from another part of the spreadsheet, but if the cell is blank it give me a Zero in the cell.  How do i get this to show a blank instead when there is no data in the field im retrieving from.

Thanks

Mark

2 Replies
Modify your formula like this:
=IF(‘Data Entry’!B34=“”,
“”,
‘Data Entry’!B34)

@markS160 

Another way is to select linked cells, Ctrl+1 and apply custom format

General;;

(or which one you use for numbers instead of General)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies