Exact function

[Greenlee]

I am trying to compare A to B cell with exact function. The problem is when there are two empty cells it returns me TRUE. I would like to return me number 0.

Thank you in advance

 

[Michael M]

Try

=IF(EXACT(A1,B1),0,FALSE)

 

[Greenlee]

I would just like to return me 0 when there are two empty cells, otherwise when there is lets say 5:5 or 10:10 then I would like to return me TRUE

 

[jtakw]

Hi,

Is this what you mean:

Book1
	A	B	C
1	5	5	TRUE
2	6		FALSE
3	10	10	TRUE
4		7	FALSE
5			0
6	5	6	FALSE
Sheet689

Cell Formulas
Range	Formula
C1	=IF(AND(A1="",B1=""),0,EXACT(A1,B1))

 

[Greenlee]

Hi,

Is this what you mean:

	A	B	C
1	5	5	TRUE
2	6		FALSE
3	10	10	TRUE
4		7	FALSE
5			0
6	5	6	FALSE

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet689​

Worksheet Formulas Cell Formula C1 =IF(AND(A1="",B1=""),0,EXACT(A1,B1)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Yes, Thank you very much!

 

[jtakw]

You're welcome, thanks for the feedback.