If two cells same , true , otherwise blank

[makinmomb]

If suppose I have numeric 30 on cell A and cell B

What is the formula on c1 to write true otherwise leave blank

I am using =exact(a1,b1) but it writes false that I don't need

[Jonmo1]

That works for me if both A1 and B1 = 30

If it's returning false for you, then the 2 cells are NOT the same.
Check for any decimal value on the cells (format both cells to show several decimals)

[Jonmo1]

I think I misunderstood the post...

To make it only show TRUE or Blank, try

=IF(EXACT(A1,B1),True,"")

[makinmomb]

Yes that is what I need , thanks

[Jonmo1]

You're welcome..

FYI, for comparing Numbers, EXACT is not required (like hitting a nail with a sledgehammer)
A simple A1=B1 works perfectly.

=IF(A1=B1,TRUE,"")


Exact is meant for comparing Text Strings where the comparison needs to be case sensitive
A1: Jon
B1: jon
=A1=B1 = True
=EXACT(A1,B1) = False

[makinmomb]

added thanks I will take your advice
before someone laughs at me