 # Finding Cell value If both are not equal

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))

@winningvish
As understanding If not equal, you should get “#NA

And use Write Cell activity to write the excel formula in the Range.

Thanks,
Suresh J

Hi Suresh,

If both cell values are not equal, like
AJ27=10.16-9.35 AL27="#N/A"
Result must be 10.16-9.35 in the cell AM27 not “#N/A”

@winningvish
Use this for below solution =IF(ISNA(A2=B2),A2,B2) Revert back if you need any help.

Thanks,
Suresh J

Hi Suresh,

Second row you got the correct value as 12 (Correct)
Fourth row also you need to get the value as 12 (InCorrect)

By using the below formula I have achieved
=IF(ISERROR(A2=B2),IF(ISERROR(B2),A2,B2),A2)

Regards
Vishnu

1 Like

@winningvish

Use this for below Solution =IF(ISNA(IF(ISNA(A2=B2),A2,B2)),B2,A2) Thanks,
Suresh J

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.