hide zero values in M365

%3CLINGO-SUB%20id%3D%22lingo-sub-2533390%22%20slang%3D%22en-US%22%3Ehide%20zero%20values%20in%20M365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2533390%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20standard%20formulas%20in%20M365%20to%20import%20information%20between%20sheets%20but%20when%20the%20criteria%20is%20null%2C%20the%20answer%20is%20being%20brought%20forward%20is%200.%20I%20want%20a%20blank.%20What%20do%20I%20need%20to%20add%20to%20my%20formulas%20to%20get%20this%20result%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2533390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am using standard formulas in M365 to import information between sheets but when the criteria is null, the answer is being brought forward is 0. I want a blank. What do I need to add to my formulas to get this result?

1 Reply

@lezli2360 

Excel formulas don't return blank as value. Most common option is to return empty string. How to do depends on formula you use, for example =IF(A1="", A1, "").

 

Alternatively you may apply custom number formats which won't show zeroes.

 

It is also setting in Excel Options not to show zeroes, but I'd not recommend it.