Replace only cells with zero values with a check mark

[edge37]

Hi, I'm looking for a way to replace a 0 value in a cell with a checkmark. In cells from E6:12, I use a formula to get percent of classes lost:

=I6/DATA!$G$3

. When class attendance is perfect the value in the cells is 0.0%. What I need is to replace that value and change it for a check mark. Other cells in the range will keep whatever value they have (no change).

Is it possible?

Thank you very much

test.xlsm
	B	C	D	E
2			ABSENTS	% LOSS CLASSES
3
4
5
6	1	JORGE	2	4.5%
7	2	LUIS		0.0%
8	3	ANA	1	2.3%
9	4	JOSE		0.0%
10	5	PEDRO	6	13.6%
11	6	JUAN		0.0%
12	7			0.0%
STUDENTS

Cell Formulas
Range	Formula
E6:E12	E6	=D6/DATA!$G$3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E6:E12	Cell Value	=0	text	NO
C6:C12	Expression	=ISNUMBER(SEARCH("REPROBADO",#REF!))	text	NO

 

[Fluff]

How about

=LET(a,D6/Data!$G$3,IF(a=0,UNICHAR(10004),a))

 

[edge37]

You Sir, are a genius. Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.