Deleting/replacing #N/A with 0

[shahed]

Hi,

I need to be able to replace #N/A from cells with a zero (0) in order do some calculations on other parts of the spreadsheet. I tried find and replace but could not get it to find it.

Please help.

Thanks

 

[texasalynn]

if the #N/A is the result of a formula you can't find/replace. You would have to change your formula that is causes this to take care of it. Care to post your formula?

texasalynn

 

[Richie(UK)]

Hi,

Welcome to the board.

Have you considered using the ISNA function within an If statement?

If you need help with this would you post the formula that you are using?