Replacing empty and NA cells with dynamic values(ex. average of 2 cells)

[deepa1]

Hi,

Can anyone please help me with this.

I want to find empty cells and cells with "NA" within a range of cells(ex:- A1: P10) and replace it with average.

Ex: If A2 is empty then A2= Average(A1,A3)
If P5 has NA within cell then P5 = Average(P4,P6)

I want to do this dynamically. So basically the find and replace is by column. Can anyone please help me with this?

Thank you.