Finding Cell value If both are not equal

[winningvish (Vishnu Vardhan)]

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

[sureshj (suresh_hserus)]

@winningvish
As understanding If not equal, you should get “#NA”
Try =IF(AJ27=AL28,A27,“Not Found”)

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

Thanks,
Suresh J

[winningvish (Vishnu Vardhan)]

Hi Suresh,

Thank you for your reply.

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”

[sureshj (suresh_hserus)]

@winningvish
Use this for below solution =IF(ISNA(A2=B2),A2,B2)

Revert back if you need any help.

Thanks,
Suresh J

[winningvish (Vishnu Vardhan)]

Hi Suresh,

Thank you for your time.

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

[sureshj (suresh_hserus)]

@winningvish

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

Thanks,
Suresh J