Manage #N/A value for a cell in excel

Help Studio
, ,
1

Hello community,
i create a datable from an exported excel file, the problem is that i can’t detect if a value is equal to #N/A, i used isError but it doesn’t work, any idea please!

2

@Fatima_Ourbat,

If possible, can you attach an excel in which you’re looking #N/A value?

3

Sorry for the delay
Here is it, fh_data_import.xlsx (8.9 KB)

4

For the Read Range properties you can click the “PreserveFormat”