Strange Behavior of Excel

[hardeep.kanwar]

Hi! Experts

Why in Cell Z34 Show "FALSE" Instead of "TRUE"

Formula in Z34 is Z32=AC32

Excel Workbook
	U	V	W	X	Y	Z	AA	AB	AC
3	REGN
4
5	Today	Campus	Delhi SC	Mumbai SC	Noida SC	Total	TW	TM	CTD
6	-	7	-	-	1	8	-	2	8
7	-	-	-	-	-	-	-	-	-
8	-	19	-	-	3	22	-	2	22
9	-	2	-	-	1	3	-	1	3
10	-	4	-	-	-	4	-	2	4
11	-	22	-	-	1	23	2	10	23
12	-	15	4	-	-	19	1	9	19
13	-	-	-	-	-	-	-	-	-
14	-	-	-	-	-	-	-	-	-
15	-	5	1	-	5	11	-	8	11
16	-	4	-	-	-	4	1	2	4
17	-	5	1	-	2	8	-	3	8
18	-	3	-	-	-	3	-	-	3
19	-	4	-	-	-	4	-	1	4
20	-	25	-	-	-	25	-	4	25
21	-	8	-	-	-	8	-	1	8
22	-	19	1	51	9	80	7	29	80
23	-	4	-	-	1	5	2	2	5
24	-	-	-	-	-	-	-	-	-
25	-	14	1	-	5	20	2	9	20
26	-	16	-	-	-	16	3	3	16
27	-	1	-	-	-	1	-	-	1
28	-	-	-	-	-	-	-	-	-
29	-	1	-	-	-	1	-	-	1
30	-	2	-	-	-	2	1	1	2
31	-	-	-	-	-	-	-	-	-
32	-	180	8	51	28	267	19	89	267
33
34						FALSE
SUMMARY

 

[BarCodeWiz]

Just a guess... rounding maybe? Try something like this:

=ABS(Z32-AC32)<0.1
Or...
=ROUND(Z32,0)=ROUND(AC32,0)

 

[Sektor]

Do the following for each cell and compare results:
1. F2
2. F9

 

[hardeep.kanwar]

Just a guess... rounding maybe? Try something like this:

=ABS(Z32-AC32)<0.1
Or...
=ROUND(Z32,0)=ROUND(AC32,0)

Thnx BarCodeWiz

Last One works

 

[BarCodeWiz]

Good to hear. Lucky guess

 

[Sektor]

hardeep, did you try my method?