How to remove #N/A?

I would like to replace all of the elements #N/A of the vector with zeros
#N/A
1336.94
#N/A
#N/A
#N/A
#N/A
1271.44
1336.94
1967.27
3190.22
3207.76

3 Commenti

Jan
Jan il 19 Mag 2021
Where do you see this output? What are the values in Matlab?
Chiara Scarpellini
Chiara Scarpellini il 19 Mag 2021
I imported this from Excel
per isakson
per isakson il 19 Mag 2021
In Excel #N/A stands for "null (#N/A) values".
When (R2018b) I import numerical data that contains #N/A it is converted to NaN in Matlab. How did you import from Excel ?

Accedi per commentare.

Risposte (0)

Commentato:

il 19 Mag 2021

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by