Compare cells with (#NUM)

[stanco]

Hi, i have a table that look something below.

What formula can i use to compare A and B, and always display the cell with value in C?

A	B	C
E1234	#NUM
#NUM	E456
#NUM	P999

 

[RoryA]

You could use:

=IFERROR(A2,C2)

 

[Phuoc]

What are the results you expect?

 

[stanco]

What are the results you expect?

hello Phuoc, thanks but the answers from RoryA works, so that is fine for now.

You could use:

=IFERROR(A2,C2)

thank you RoryA once again. this works for me!