Using the ROW function embedded in a formula.

[Eloise T]

=IF(A1<>B1,("A"(ROW())" ≠ B"(ROW())),"")
__logical test_______value if true______value if false

My spreadsheet has two very long columns; both columns are formatted for currency. I'll call them Columns A and B for simplicity. The above formula does not work; however, it shows what I'm trying to accomplish.
To wit: Check the two cells in the same row to see if they are not equal.
If they are not equal (TRUE value) then display "A1 ≠ B1" using the ROW function to determine what the row is to plug in after the Column letter. If the two adjacent cell values are equal (FALSE value), do nothing.

Is it possible to modify this formula to work in Excel or a better way accomplish the same job using a completely different formula?

 

[Nebu]

Hi:

Your formula is constructed wrongly.

Try this

=IF(A1<>B1,"A"&ROW()&" ≠ B"&ROW(),"")

Thanks

 

[Eloise T]

Hi:

Your formula is constructed wrongly. incorrectly.

Try this

=IF(A1<>B1,"A"&ROW()&" ≠ B"&ROW(),"")

Thanks

THANK YOU! You are definitely a Ninja!

 

[Khalid NGO]

or this to get col name without hard-coding:

=SUBSTITUTE(IF(A1<>B1,CELL("address",A1)&" ≠ "&CELL("address",B1),""),"$","")

Regards,

 

[Eloise T]

or this to get col name without hard-coding:

=SUBSTITUTE(IF(A1<>B1,CELL("address",A1)&" ≠ "&CELL("address",B1),""),"$","")

Regards,

Thank you!