Handle that using ISNA() as below

=IF(ISNA(A2),AVERAGE(A1,A3),A2)

If this post helps click Yes
---------------
Jacob Skaria


"Rahim" wrote:

I want to tell excel that IF A2 has "#N/A", AVERAGE (A1,A3), A2
but it don't work, any help is highly appreciated, thanks