Hi,

You haven't told us what you want to do if A2 is not NA? One solution based
on your question as written is:

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


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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