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.

ex

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

@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

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”

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

Thanks,
Suresh J

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

1 Like

@winningvish

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

Thanks,
Suresh J

1 Like

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