# Thread: Exact function Thanks:  1 Post #5310580 (1) Likes:  1 Post #5310577 (1)

1. ## Exact function

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.

2. ## Re: Exact function

Try

Code:
`=IF(EXACT(A1,B1),0,FALSE)`

3. ## Re: Exact function

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

4. ## Re: Exact function

Hi,

Is this what you mean:

ABC
155TRUE
26FALSE
31010TRUE
47FALSE
50
656FALSE

Sheet689

Worksheet Formulas
CellFormula
C1=IF(AND(A1="",B1=""),0,EXACT(A1,B1))

5. ## Re: Exact function

Originally Posted by jtakw
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
Sheet689

Worksheet Formulas
Cell Formula
C1 =IF(AND(A1="",B1=""),0,EXACT(A1,B1))
Yes, Thank you very much!

6. ## Re: Exact function

You're welcome, thanks for the feedback.