How to use Function IF

[John]

I have two columns for which I would like to compare data.
That is for example cell A5 equals cell B5 then C5 returns
a value of TRUE or YES.
Any assistance is appreciated.

John

 

[Govind]

Hi John,

Use this formula in cell C5

=IF(A5=B5,"TRUE","FALSE")

Regards

Govind.

 

[Arvi Laanemets]

Hi

=(A5=B5)

 

[John]

Thanks, this works well but now as the learning curve is
increasing. How can I write the formula so that if both or
one of the cells are empty I don't get a TRUE or FALSE
result?

John

 

[Biff]

Hi!

Try this:

If either cell is blank the formula cell will also be
blank:

=IF(OR(A5="",B5=""),"",IF(A5=B5,"TRUE","FALSE"))

Biff