# 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.

Thank you in advance  Reply With Quote

2. ## Re: Exact function

Try

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

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  Reply With Quote

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))  Reply With Quote

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!  Reply With Quote

6. ## Re: Exact function

You're welcome, thanks for the feedback.  Reply With Quote

## User Tag List

#### Tags for this Thread

cells, exact, function, return, true #### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•