Hi Everyone,

How to write Excel Formula to get the value, if the both cells are not equal.

As attached,

if both cells are equal, the formula will return the AJ cell value

if both cell values are not equal Its need to return the cell value except β#N/Aβ

I have tried with below methods, but no luck

=IF(AJ27=AL27,AJ27,IFERROR(AJ27,AL27))

Can any one please help