Formula IF

[Alex70]

Hello,

I'm using this formula =IF(J5=L5;1) to determine if those cells are equal, since both cells are blank I'm getting the 1 answer and I just want to get the answer if both cells have data.

[Paul Johns]

=IF(J5=L5,"both cells have data","")
True answer will give you a message of "both cells have data".
False answer will give you a blank.

or if you want to see what value is in the cells.

=IF(J5=L5,J5,"")

Hope this helps.

[Alex70]

Thank you but I' actually need the 1 answer but just as long as both cells are equal with data.

[jeffreybrown]

How about...

=IF(COUNT(J5,L5)<2,"",IF(J5=L5,1,""))

[NBVC]

or

=IF(AND(J5=L5,J5<>"",L5<>""),1,"")

[Alex70]

Thank's a lot that solved it.

[jeffreybrown]

If you are satisfied with the answer provided, please mark your thread as solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save