Array Formula #N/A

[ravibemail]

Hi,

Is is possible to replace #N/A with space in the array formula range?

Thanks,
ravi.

[FDibbins]

without seeing what your formula is, and what the references etc are, try using iferror() at the start

=iferror(your-formula," "

[Nels]

Or you can try

=If(Type(your-formula)=16, " ",

[ravibemail]

Hi Thanks for the repllies.
But neither works. What I am trying to do is , lets say I have values in A1:A5 , I want to copy this to D1:D6 using the array formula {=A1:A5}, as A6 is not selected D6 will be #N/A .
I want such fields to be filled with space instead of #N/A.

any ideas.

thanks,
ravi

[zbor]

Can you write your formula?

[ravibemail]

Hi,
find the attached sheet with example. Look at the cell D6, any ideas to have a space instead of #N/A is helpful.

thanks,
ravi.

[FDibbins]

you need to extend your array down to the last row. it is going down to A5, but you also have it in A6

[ravibemail]

Hi,
thanks, that works. However I am trying to keep it deliberately to A5 for a scenario. Trying if there is way to achieve this.

thanks,
ravi.

[zbor]

Either extend formula to =A1:A6 either don't write it in D6