Suppressing zeros

[Eric W]

Eric W submitted a new Excel article:

Suppressing zeros - How to display a blank cell instead of a zero as a result of a formula

A frequent question on the forums is "how do I not display a zero?" There are several methods to do so, each with their own pluses and minuses. I will explain the various methods here as a guide, and the interested user can choose the one most suited to their situation.

Consider this worksheet...

Read more about this Excel article...

 

[CA_Punit]

A similar option using "If" function

Book1
	D	E
22	Name	code
23	Buford	def
24	Candace
25	Isabella	0
26	Perry	123
Sheet2

Cell Formulas
Range	Formula
E23:E26	E23	=VLOOKUP(D23,IF($A$2:$B$10="","",$A$2:$B$10),2,0)